Calculating hours and minutes over multiple days.

[Megnarium]

Hi Guys

I am using a text formula in Excel (=INT(B4-A4)&" days "&TEXT(B4-A4,"h"" hrs ""m"" mins """) to calculate Days, hours and minutes from a start and end time. What I need though is the display only in hours and minutes. I cant figure out how to either manipulate the formula above or use a completely different one.

Thanks!

Here is an example of the excel start date/time, end date/time and calculated days, minutes hours.

(2022-03-21 14:17 2022-03-24 14:30 3 days 0 hrs 13 mins

[JohnTopley]

try

=B4-A4

Format as [h]:mm

[janmorris]

if you want the result as a number in hours and minutes, you could use Custom format of:

Please Login or Register  to view this content.

but if you want the words "hours" and "mins" included, then you can use Custom format of:

Please Login or Register  to view this content.

OR, you could use this formula:

Please Login or Register  to view this content.

[FlameRetired]

Removed by FR

[FlameRetired]

Removed by FR

[FlameRetired]

Removed by FR