I would say use 3 integer fields.
Min's
Seconds
Storage
Min's would hold the number of min's
Seconds
Storage would store (via filter) min's*60+seconds
You can use your storage field to do all of your calculations on
Then for display you can update min's to be storage/60
And seconds would be storage%60 (yes that's a %...it gives you the remainder
of a division problem)
I think that would work for what you are trying to do...if Hours are needed
then you can just add it to the mix
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of adamucci
Sent: Wednesday, February 07, 2007 12:23 PM
To: arslist@ARSLIST.ORG
Subject: Elapsed Time field
Hi All...I'd like to enter some time data into a single field. so if
something takes 3 minutes and 22 seconds i'd like to enter 3:22 into a
field. It seems like a time field will not work, since the i would have to
put 3:22 AM or PM in there. I am also going to have to do some calculations
on the field such as total and meanso I don't think i can use a
Character field.
Does anyone have a suggestion on how I could format that field, or add
workflow, so this could be done?
Thanks!
John
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"