Count Hours between dates and time given

  • Thread starter Thread starter Joyce Oakes
  • Start date Start date
J

Joyce Oakes

Hello,

Is there a formula that can count the total of hours
between :

Feb 3rd 2004 @ 14:20 to Feb 4th 2004 @ 15:30 ?

Thanks
Joyce
 
Not if you include the at sign,if indeed they are real dates with times use

=end-start

and format as [h]:mm

Actually you can count the hours even if it is text but it will be a pretty
messy formula,
 
Back
Top