Calculating number of hours between two days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top