Subtract and Add times

[tufmarkerr]

I am trying to figure out hours and minutes worked. The worksheet is
set up as follows:

Column A is formatted as 13:30
Column B is formatted as 13:00
Column C =B1-A1 00:30 (30 mins)

At the top of Column C I have =SUBTOTAL formula. After the total
reaches 24 hours, it starts over at 00:00. I want to see hours and
minutes greater than 24 hours (ex. 50 hours and 35 minutes might look
like 50:35, or is it possible for a formula to display a result to look
like 50hr 35min). How can I use the =SUBTOTAL and still convert to
hours and minutes past 24 hours?

 

[Biff]

Hi!

Format your formula cell as Custom: [h]:mm

The brackets [] keep the hours from rolling over back to 0.

Biff

 

[tufmarkerr]

That works great. Thanks