The question was put forward in a previous post by another forum member:
"Im trying to calculate hours and minutes between two dates/times over more than 24hrs".
The solution given was:
How about simply: =B1-A1 custom formatted as [h]:mm
Great information above and appreciated.
My question extends this to:
What if I just want minutes.
=B1-A1 custom formatted as [h]:mm will give me 16:03 not 963.
Any help would be appreciated.
=(b1-a1)*1440
Last edited by shg; 04-07-2009 at 12:09 AM.
Entia non sunt multiplicanda sine necessitate
Thank you very much for you help Shg.
Appreciated.
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks