![]() |
column of times, such as 2:30, 2:14, etc. how do I sum them?
|
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. |
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