How to Calculate Total Hours & Minutes in Excel Over 24 Hours | Formula to SUM Time #short

In this Microsoft Excel video tutorial I explain how to sum times where the total duration exceeds 24 hrs. The solution to this is in how you format the time.
------------------------

[roquemusic]

To the point, exactly what I needed. Thanks!

[Sndhf]

You were short, sweet and result oriented. Unlike other folks on net who create unnecessary garbag time addition. Genius.. thanks

[misterwill]

Wow😯More than once, this would have been useful over the years and now I’m ready to handle it in future cases. Thank you.

[BenDieselBasicAutomotive]

Thank you very much, Sir.... for the learning!....

[jafarkasoma]

Was looking for something exactly like this, so helpful and thank you

[jsjsnyk]

Hello.How to calculate working hours per month in dynamic calendar

[Matt-pxzd]

A little detail on what the brackets are doing would be great 👍

[ashishshingrut]

How to use same with powerbi powerquerry

[garybaitson]

but is there a way to show the time with a 'h' and a 'm' in it.. Like 8h:55m ?

[itswalieee]

What if i make it with spreadsheet? Any tips?

[dhm.]

Why do I always get 00:00 if I Sum a range? It only work if I manually added cell+cell but I have around 500 cells to sum!

[hochbau_facharbeiter_netzwerk]

How do you transform 32 hours into working days? Example...one working day has 9 hours?

[bernardobenvegnupasinatto]

Well done but if you format as time there is an option for this