Time in excess of 24 hours

[JordanR]

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?

 

[KeithG]

could you record the start time and end time?

 

[MStCyr]

this will work across midnight

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

Author: Terry Kreft

 

[JordanR]

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?

 

[ColinEssex]

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

 

[kleky]

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