Convert Minutes to 'Hours/Minutes'

jt5 · Jul 20, 2004

I am trying to calculate elapsed time between two times and put the result in Hours/Minutes in Microsoft Access. I want to export the details to Excel and accumulate the overall totals in Hours/Minutes. Is there a simple way to do this?
I have tried converting to minutes; exporting to Excel and recalculating the minutes to Hours/Minutes in Excel but I want to set this up for someone who does not understand how to recalculate in Excel and just wants a 'correct' total figure.

PHV · Jul 20, 2004

And what about Format(ElapsedTime, "hh:nn") ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Convert Minutes to 'Hours/Minutes'

jt5

IS-IT--Management

PHV

MIS

Similar threads

Part and Inventory Search

Sponsor