ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   column of times, such as 2:30, 2:14, etc. how do I sum them? (https://www.excelbanter.com/excel-worksheet-functions/239294-column-times-such-2-30-2-14-etc-how-do-i-sum-them.html)

lallen

column of times, such as 2:30, 2:14, etc. how do I sum them?
 


Harlan Grove[_2_]

column of times, such as 2:30, 2:14, etc. how do I sum them?
 
Put your question into the BODY of your post, not in the subject line.

If your time values are numbers (they could be text that just looks
like numbers), just sum them like any other numbers, but you'd need to
give the result a number format like [h]:mm or [m]:ss depending on
whether your 2:30 and 2:14 times are hours:minutes or minutes:seconds.
The [h] and [m] format parts show hours = 24 or minutes = 60,
respectively.

Fred Smith[_4_]

column of times, such as 2:30, 2:14, etc. how do I sum them?
 
Use the Sum function.

Regards,
Fred

"lallen" wrote in message
...




All times are GMT +1. The time now is 12:57 PM.

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