Thread
:
Calculating number of hours and minutes
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Calculating number of hours and minutes
Try this
=INT(A1-A2)*24&" hours "&INT(MOD((A1-A2),1)*60*24) & " minutes"
--
Don Guillett
SalesAid Software
"Neville" wrote in message
...
Please can someone tell me how to calculate the number of hours and
minutes
between two times, where the two times span more than 24 hours?
For example, if the starting date/time is 24 Dec 13:00 and the ending time
is 27 Dec 13:30, then the number of hours and minutes lapsed is 72 hours
30
minutes.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett