How do I calculate the number of days hours minutes and seconds between 2 date & time
I am looking for a way to calculate the number of Days, Hours, minutes and Seconds between 2 dates and times:
eg.
A1 = 10/10/11 B1 = 15/10/11
A2 = 1:30:00 B2 = 13:30:00
I would also like the answer to apear in number formay:
eg.
A3 = 5.5 Days
Any help with my question will be greatly appreciated.
Thank you
To get the answer in decimal days is a simple
=B1+B2-A1-A2
format result cell as number
If you want the answer to be in days, hours, minutes and seconds try
=INT(B1+B2-A1-A2)&" days "&TEXT(B2-A2,"h:mm:ss")
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks