|
Question
I want to make a sum of a time field but I can't get the time above 23 hours. I am looking for a time field that can give me 110 hours can you help me?
Answer
Try one of these:
Note: Change the [TimeExample] fields to the name of your Field.
This first one is the adding of two time fields in a query:
SumTime: Format(([TimeExamples]+[TimeExamples1])*24,"#.0" & " Hours")
This second one is the sum of a field in a form:
=Format(Sum([TimeExamples])*24,"#.0") & " Hours"
These formats will display the result as: 136.8 hours. The final part is in decimals, so you may wish to change these back to minutes.
Do you like this tip? Subscribe to my weekly Newsletter to receive tips
weekly via email.
Click Here to subscribe.
|
