View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Calculating number of hours and minutes

=last date - first date
and format userdefined as [h]:mm


"Neville" skrev:

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.