Hours and Minutes
Hours and Minutes
(OP)
I have a field in my table that stores time...it is formatted for Short Time. The issue...this field shows how long it takes to do a task. Sometimes it takes over 24 hours. The field errors out if I enter more than 23:59. I would like the field to stay formatted to HH:MM but I need to exceed 24 hours.
Can anyone help?
Can anyone help?
RE: Hours and Minutes
You are attempting to record an elapsed time or time interval. Use a fieldtype like Long and store the elapsed time as minutes (assuming that you don't care about seconds). You can then easily format that in a query with
Format(Int(ElapsedTime/60), "00") & ":" & Format((ElapsedTime Mod 60), "00")
RE: Hours and Minutes