Calculate Date and time

D

Douglas

I would like to know how to calclate date and time "01-02-2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
 
F

Frank Kabel

Hi
if both values are in A1 and B1 enter the following formula
=B1-A1
and format this cell with the custom format
[hh]:mm
-----Original Message-----
I would like to know how to calclate date and time "01-02-
Click to expand...
2004 16:00" to "02-02-2004 15:20". Iwould like to get the
answer in hours.
 
Top