Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Time
I would like to take the average of a list of times in the format HH/MM/SS
but I get gibberish. Why is this and how do I return and average value from this data set with the format HH/MM/SS? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Time
Peter,
If you are summing dates that are already in HH:MM:SS format, you will likely run into a challenge when you exceed 24 hours as the clock will then roll. If you are using whole numbers, like 8, to designate 8 hours and are displaying that in date format, you are not going to see 8 hours, but zero, the rollover of 8 days. -- http://HelpExcel.com "PeterM" wrote: I would like to take the average of a list of times in the format HH/MM/SS but I get gibberish. Why is this and how do I return and average value from this data set with the format HH/MM/SS? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Time
Hi Peter
Just use =AVERAGE(A1:A10) where A1:A10 hold your times. Format the cell with formula FormatCellsNumberCustom[hh]:mm:ss to allow for an average which exceeds 24 hours. -- Regards Roger Govier "PeterM" wrote in message ... I would like to take the average of a list of times in the format HH/MM/SS but I get gibberish. Why is this and how do I return and average value from this data set with the format HH/MM/SS? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Time
If you've got times rolling over beyond the 24 hour mark, use the cell
format [h]:mm:ss. -- David Biddulph "galimi" wrote in message ... Peter, If you are summing dates that are already in HH:MM:SS format, you will likely run into a challenge when you exceed 24 hours as the clock will then roll. If you are using whole numbers, like 8, to designate 8 hours and are displaying that in date format, you are not going to see 8 hours, but zero, the rollover of 8 days. -- http://HelpExcel.com "PeterM" wrote: I would like to take the average of a list of times in the format HH/MM/SS but I get gibberish. Why is this and how do I return and average value from this data set with the format HH/MM/SS? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Time
What sort of times do you have, clock times, i.e. the time something
happened, or elapsed times, e.g. for a running race, for instance? "Roger Govier" wrote: Hi Peter Just use =AVERAGE(A1:A10) where A1:A10 hold your times. Format the cell with formula FormatCellsNumberCustom[hh]:mm:ss to allow for an average which exceeds 24 hours. -- Regards Roger Govier "PeterM" wrote in message ... I would like to take the average of a list of times in the format HH/MM/SS but I get gibberish. Why is this and how do I return and average value from this data set with the format HH/MM/SS? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with averaging a time but dates are messing up the result I am trying for. | Excel Worksheet Functions | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Automating averaging a column over time periods. | Excel Discussion (Misc queries) | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions |