Calculating number of hours between two days
 

I wish to calculate the number of hours between two points in time.
For instance if I subtract 21-10-2005 12:10:00 from 22-10-2005 14:10:00
Excel should give 26:00:00 as the result. Can anyone answer?

Calculating number of hours between two days
 

Just subtract one from the other and format as [h]:mm:ss if you want it as
time, if you want bit as decimal use =(A21-A20)*24 and format as General

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NMM" wrote in message
...
I wish to calculate the number of hours between two points in time.
For instance if I subtract 21-10-2005 12:10:00 from 22-10-2005 14:10:00
Excel should give 26:00:00 as the result. Can anyone answer?