Time in excess of 24 hours

JordanR

Registered User.
Local time
Yesterday, 20:56
Joined
Jan 25, 2005
Messages
72
Looking to have a time field that a user can enter how long they worked an issue. Format should be ##:##, but I'm afraid that if I use text, calculations will be impossible.
How does someone do this if it's expected that the value will frequently go over 24 hours?
 
could you record the start time and end time?
 
this will work across midnight

Format([StartTime] -1 -[EndTime], "Short Time")

Author: Terry Kreft
 
Not quite what I'm looking for. I'm just trying to make a field where someone can enter how much time they've spent on an issue by saying 1:15 instead of 1.25 when trying to say 1 hour and 15 minutes or 27:45 instead of 27.75.
My complication comes in that I will invariably have to do math with the field, so I need to to look at it as time and not a number.
Is this possible?
 
If someone spends 45hrs and 22mins on a job then its not "Time". Its a number that happens to be hours and a number that is minutes. Have 2 fields one for each and set them to number.

What calculation do you need to do on it?

Col
 
Thats right, its just 2 fields.

field 1: hours

number of days = hours / 24

field 2: minutes

validate as to only allow >0 and <=60

you can store the above however you like. days/hours/minutes, hours/minutes, or just minutes (hours * 60 + minutes).

Its all about the math i reckon

:)
 

Users who are viewing this thread

Back
Top Bottom