Date and Time calculation

S

sacravia

I am looking to calculate the difference between two dates and times bu
am unable to get it to compute more than 24 hours.

A1=10/18/2004 8:00 B1=10/18/2004 8:00

TEXT(B1-A1,"h:mm:ss")

This gives 0 hours. What is needed to convert the date as well into th
equation. This is time sensitive and look forward to your reply.

Thanks
 
A

Arvi Laanemets

Hi

=B1-A1
and format result as Custom "d hh:mm:ss" or "[h]:mm:ss"
(2nd format displays difference in hours)
 
Top