Display lapsed time in hours and minutes

[Guest]

How do I display total lapsed time in hours and minutes if the total lapsed
time exceeds 24 hours? (IE: in a report, a lapse of 25:30 will actually show
up as 1:30) I am tracking time in minutes per day, but need to know the
total number of minutes for the entire year. Help!

 

[Duane Hookom]

Doug Steele has a function that should work for you at
http://www.accessmvp.com/djsteele/Diff2Dates.html.

 

[Guest]

When I type in the Datediff formula, and attempt to give it more than one
criteria (in my case, "hn"), I get #Error appearing in the query datasheet
view. Is this because I am using Access 97?

This is the formula that I am typing in:
Minutes Down: DateDiff("hn",[Down From],[Down To])

 

[Duane Hookom]

If you want to use Doug's function, then use Doug's function name:
MinutesDown: Diff2Dates("hn",[Down From],[Down To])


--
Duane Hookom
MS Access MVP

When I type in the Datediff formula, and attempt to give it more than one
criteria (in my case, "hn"), I get #Error appearing in the query datasheet
view. Is this because I am using Access 97?

This is the formula that I am typing in:
Minutes Down: DateDiff("hn",[Down From],[Down To])

Doug Steele has a function that should work for you at
http://www.accessmvp.com/djsteele/Diff2Dates.html.