| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs
We need to list times in 'minutes' and 'seconds' as recorded on a stopwatch
and then have excel perform simple calculations such as SUM or AVERAGE. There appears to be no option to format cells for this sort of time without having to have dates and AM/PM associated with them. I imagine angles (measured in minutes and seconds) have the same problem... 1 min 30 seconds could be represented as 1'30", yet still there appears to be no allowance for this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter Time in cells | Excel Discussion (Misc queries) | |||
| Remove Hyperlinks from multiple cells at the same time | Excel Discussion (Misc queries) | |||
| Cells with time format and calculating the diffrence | New Users to Excel | |||
| How to get Excel to stop formatting time cells incorrectly | Excel Discussion (Misc queries) | |||
| split combined Time Date cells | Excel Discussion (Misc queries) | |||
Threaded Mode
