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

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!

[@Sn175dhf]

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

[@misterwill3625]

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!....

[@matarishwan10]

Thanks its useful and quick.

[@sahanaahada5510]

Thank you

[@user-js7js6ny3k]

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

[@NeLzKieTV]

Very helpful

[@ChesterTugwell]

Glad to hear that

[@fixit-academy]

Thanks!

[@ChesterTugwell]

Many thanks

[@ahmadaltayeb1983]

Thanks

[@JacekKotarba]

thanks

[@pedrocristobal8631]

thank u man it is a big help for me.

[@jafarkasoma9289]

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

[@sachinpal8273]

Very Helpful. ❤

[@ashishshingrut8335]

How to use same with powerbi powerquerry

[@itswalieee]

What if i make it with spreadsheet? Any tips?

[@nintendork2442]

Perfect, thanks!

[@garybaitson]

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

[@mursaleenvaskii5786]

Nice

[@ChesterTugwell]

Thanks

[@RJMuhammedNaeem]

Thank you so much

[@redfishbum]

Thank you!

[@Ravi_Kumar_Kateya]

Thank you, Sir

[@silvestrecamposano6317]

Thank you!...

[@sirmarkusofficial]

Thank you ❤

[@meltul]

Good Day
And for a 24 hour cycle?

[@asankaperera5159]

Thank you 👍

[@lucasll2198]

Brilliant

[@Matt-px7zd]

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

[@hochbau_facharbeiter_netzwerk]

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

[@dhm98.24]

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!

[@RAMESHS-vf6vc]

Tq sir..

[@bernardobenvegnupasinatto7090]

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

[@robertomoreno990]

Why do I get zero?

[@JaneDoe-tv6dw]

Thank you

[@priyankarajendiran1083]

Thank you