Date & time substraction

  • Thread starter Thread starter VINAY DALMIA
  • Start date Start date
V

VINAY DALMIA

Cell A1 13/01/2008 10:25 AM

Cell A2 17/01/2008 06:10 PM

How to acheive difference between cell A2 & A1 in hours?

Thanks in advance

Vinay Dalmia
 
=a2-a1
and give this cell a custom format of:
[hh]
or
[hh]:mm
or
[hh]:mm:ss
or whatever you like.
 
Assuming you want hours as a floating point number...

=24*(A2-A1)

Rick
 
Back
Top