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
|