ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   to sum times (https://www.excelbanter.com/excel-worksheet-functions/46199-sum-times.html)

Luis

to sum times
 
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.

Harald Staff

As Nike says: Just do it.

You may have to format the result cell as [h]:mm to prevent a "midnight
reset". Unless you have an available numberformat saying 37:30:55. The
basque have, the danes don't. Go figure.

HTH. Best wishes Harald

"Luis" skrev i melding
...
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.




Anne Troy

Format the resulting cell (25:00) as [h]:mm
See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Luis" wrote in message
...
how I do to sum times.
ex.: 10:00 + 15:00 = 25:00 Hs.

Tks.





All times are GMT +1. The time now is 05:56 AM.

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