Date & time substraction

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
 
D

Dave Peterson

=a2-a1
and give this cell a custom format of:
[hh]
or
[hh]:mm
or
[hh]:mm:ss
or whatever you like.
 
R

Rick Rothstein \(MVP - VB\)

Assuming you want hours as a floating point number...

=24*(A2-A1)

Rick
 
Top