Hi,
I'm trying to obtain a formula that will calculate the difference in time between two dates showing the result in hours and minutes.
I pulled this from another thread which gives the result in days:hours:mins
=INT(B1-A1)&" days "&TEXT(B1-A1,"h"" hrs ""m"" mins ""s""secs""")
what changes need to be made to show the result in hours:mins?
Bookmarks