| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
column of times, such as 2:30, 2:14, etc. how do I sum them?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to average times in a column | Excel Worksheet Functions | |||
| Adding minutes in second column to times in first column | Excel Worksheet Functions | |||
| how do i count how many times x in column a = 1 or 2 in column b | Excel Worksheet Functions | |||
| merge dates and times into one column? | Excel Discussion (Misc queries) | |||
| How do I count how many times x appears in a column? | Excel Worksheet Functions | |||
Linear Mode
