Display lapsed time in hours and minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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])
 
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

BC Bywater said:
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 said:
Doug Steele has a function that should work for you at
http://www.accessmvp.com/djsteele/Diff2Dates.html.
Click to expand...
Click to expand...
 
Back
Top