| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Averaging time
I have columns with data in the following formats:
Column A Column B Column C 12/7/2004 2:00:00 PM 3:51:00 12/7/2004 5:51:00 PM B1 being =C1-A1 and ColB being formatted to HH:MM:SS using time value. I then want an average of the time values in all of ColB. Somewhere the logic breaks if I try to do =AVG(B1:B255) though. Kat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
Threaded Mode
