View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Calculate toal hours

=B1-A1, and format as [h]:mm, if you want the output as hours and minutes in
Excel time format.
=(B1-A1)*24, and format as number or general, if you want decimal hours.
--
David Biddulph

"Vinu" wrote in message
...
Need to calculate total hours of two different date & time & difference
between day & time.
e.g A1= 8/15/2008 22:30
B1=8/20/2008 22:33
Output=?

Thanks in Advance