Adding Times in Short Time Format

[Guest]

I am using Access 2003. One of the fields in my program is is the passage of
time. I take one time entry (Finish) and subtract another time entry (Start)
to get the amount of time spent on a task (Finish - Start = "Total_Time).
All of these times are formated in Short Time Format (hh:nn). This works
great until I try to get the Sum of "Total_Time". It works fine until the
total goes over 23:59. The hours start over. So instead of getting "38:51",
I get "14:51".

Is there a way to get around this and get the hours to show the complete
total? I do not want to show days:hours:mins either.

Thanks in advance....
Balfour211

 

[Guest]

So instead of getting "38:51", I get "14:51".

See the Timesheet form in the sample that you can download with this article:

On time and how much has elapsed
http://office.microsoft.com/en-us/assistance/HA011102181033.aspx

The Control Source for the textbox in the subform's footer calls the
HoursAndMinutes function that is given in this article:

=HoursAndMinutes(Sum([TimeOut]-[TimeIn]))


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________