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.

[@NeLzKieTV]

Very helpful

[@ChesterTugwell]

Glad to hear that

[@jafarkasoma9289]

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

[@pedrocristobal8631]

thank u man it is a big help for me.

[@sachinpal8273]

Very Helpful. ❤

[@nintendork2442]

Perfect, thanks!

[@sahanaahada5510]

Thank you

[@RJMuhammedNaeem]

Thank you so much

[@fixit-academy]

Thanks!

[@ChesterTugwell]

Many thanks

[@redfishbum]

Thank you!

[@ahmadaltayeb1983]

Thanks

[@sirmarkusofficial]

Thank you ❤

[@Ravi_Kumar_Kateya]

Thank you, Sir

[@mursaleenvaskii5786]

Nice

[@ChesterTugwell]

Thanks

[@Matt-px7zd]

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

[@jamespawelek-lacey1778]

Without the brackets it calculates what time it would be when the total number of hours have passed since the beginning of time as far as the computer is aware of, so after midnight on 1st Jan 1900

[@silvestrecamposano6317]

Thank you!...

[@lucasll2198]

Brilliant

[@garybaitson]

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

[@user-js7js6ny3k]

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

[@meltul]

Good Day
And for a 24 hour cycle?

[@RAMESHS-vf6vc]

Tq sir..

[@itswalieee]

What if i make it with spreadsheet? Any tips?

[@hochbau_facharbeiter_netzwerk]

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

[@ashishshingrut8335]

How to use same with powerbi powerquerry

[@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!

[@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

[@JacekKotarba]

thanks

[@asankaperera5159]

Thank you 👍

[@priyankarajendiran1083]

Thank you