ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to add up hours and minutes? (https://www.excelbanter.com/excel-discussion-misc-queries/125120-how-add-up-hours-minutes.html)

soup

How to add up hours and minutes?
 
I would like to know how I can add up the hours, minutes and seconds in this
format:

02:19:53 (2 hrs19mins53s) + 01:11:51 (1hr11mins51s) = 3hrs31mis44s

Thanks for your help in advance!

Bob Phillips

How to add up hours and minutes?
 
=A1+A2

as it is just numbers. If the total is likely to exceed 24 hours, format the
result cell as [h]:mm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"soup" wrote in message
...
I would like to know how I can add up the hours, minutes and seconds in

this
format:

02:19:53 (2 hrs19mins53s) + 01:11:51 (1hr11mins51s) = 3hrs31mis44s

Thanks for your help in advance!





All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com