Date and Time calculation

  • Thread starter Thread starter sacravia
  • Start date Start date
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
 
Hi

=B1-A1
and format result as Custom "d hh:mm:ss" or "[h]:mm:ss"
(2nd format displays difference in hours)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if night shift by start & end time 2
[NEWBIE] date/time diff 4
Average Time for Specific Item 9
Calc time with a lookback #2 7
Converting dd:hh:mm to [h]:mm not working. 3
How to calculate Premium Time 2
How do i Calculate minutes between two different dates 5
Length of time from date/time custom format 2

Back
Top