Have a Question?

If you have any question you can ask below or enter what you are looking for!



Excel: calculating total time

Hi,

I want to calculate the total time in Hrs,Minutes and Seconds.


10:30
23:40
43:12:00
34:07:00
12:34
12:53

13:23

Please Suggest


  Sachin Yadav

Hi Sachin,

Just use sum function to calculate total time thereafter goto format cell-> Numbr->Time

And select 37:30:00 format. Now u will be able to see total time in hrs, minute and seconds.

Regards

Devendra

  Devendra Singh       05 Jul 2016       2       0     

  Devbrat Tripathi       30 Jul 2016       0       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any