Thread: Calculate toal hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Calculate toal hours
Try

=B1-A1

format as [hh]:mm

Mike

"Vinu" wrote:

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


Reply With QuoteReply With Quote