I am wanting to subtract two dates and times and have them display as d:hh:mm. However, excel "rolls over" the days once it goes beyond 31 as shown below. I am also wanting to use this d:hh:mm for numerical calculations.
2.17.15 12:00
1.17.15 6:00
31:06:00 - d:hh:mm
31.25
2.17.15 12:00
1.16.15 6:00
01:06:00 - d:hh:mm
32.25
Thanks
See the formula here and give it a go...
http://answers.microsoft.com/en-us/o...c-889eedeba755
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
May be a bit more "natural language":
Formula:
Please Login or Register to view this content.
MOD(A1,1) returns just "hour portion" of date so one is substarczted from datedif if the hour of finish is before hour of start
Best Regards,
Kaper
That will work well enough for what I need! Thanks!
Glad to hear that and thanks for the reputation point. Would be also lovely if you mark thread SOLVED
- please select Thread Tools from the menu link above your original post, and mark this thread as SOLVED.
Thanks.
And thanks from me, too...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks