time problem again

[bob]

Hi there
Iam having a hard time with calculating time that goes into the next date ex.
starttime 16:25:30
endtime 05:25:30
TotalTime 13:00:00
but the problem is that what ever i use is not working to calculate that time
I was wondering is there a better way to do this kind of calculation.
possibly making this into a decimal. Please explain in simple terms. I do
want to put this in a field or unbound text box to appear in a form I do have
a field in a table that is labled TotalTime and tht is where i want to put
this calculation

thank you for the help

 

[pietlinden]

Hi there
Iam having a hard time with calculating time that goes into the next dateex.
starttime 16:25:30
endtime 05:25:30
TotalTime 13:00:00
but the problem is that what ever i use is not working to calculate that time
I was wondering is there a better way to do this kind of calculation.
possibly making this into a decimal. Please explain in simple terms. I do
want to put this in a field or unbound text box to appear in a form I do have
a field in a table that is labled TotalTime and tht is where i want to put
this calculation

thank you for the help

Date/Time: Calculate differences in time
Author(s)
Terry Kreft

You can use the following logic to calculate the difference between
two times which works even across midnight.

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

 

[pietlinden]

Hi there
Iam having a hard time with calculating time that goes into the next dateex.
starttime 16:25:30
endtime 05:25:30
TotalTime 13:00:00
but the problem is that what ever i use is not working to calculate that time
I was wondering is there a better way to do this kind of calculation.
possibly making this into a decimal. Please explain in simple terms. I do
want to put this in a field or unbound text box to appear in a form I do have
a field in a table that is labled TotalTime and tht is where i want to put
this calculation

thank you for the help

If you use a General Date dd/mm/yyyy hh:nn:ss then you can use the
function I just posted. Otherwise, you have to figure out which day
the start time and end time are on and adjust your calculations
accordingly. Being obscenely lazy, I'd just store the date in there
too.