Hi team im wondering if you can help!
Im trying to calculate hours and minutes between two dates/times over more than 24hrs.
I have:-
A1 is 18/10/08 13:14, B1 is 20/10/2008 12:20, C1 is 1:23:05
Using the formula C1 =INT(B1-A1)&TEXT(B1-A1,":hh:mm")
But what I really need is just Hours and Minutes so the above should read 47:05 !!!!!
This has stumped me, any help much appreciated
Regards
Aid
Bookmarks