Count Hours between dates and time given

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
 
P

Peo Sjoblom

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,
 
Top