Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the average time?
I subtracted one time from another to get the HH:MM. Now I need to find the
average of all the times. When I Average(range of times) I do not get an accurate time (I manually checked it by changing the HH:MM to straight minutes. Is there a way to average time in Excel? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the average time?
Time (and dates) are just numbers to excel.
=average(a:a) should work. Any chance that the times weren't enter correctly? SharonTraff wrote: I subtracted one time from another to get the HH:MM. Now I need to find the average of all the times. When I Average(range of times) I do not get an accurate time (I manually checked it by changing the HH:MM to straight minutes. Is there a way to average time in Excel? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the average time?
The times were entered as "12:36" etc., then as "9/13/06 12:36". I have
tried to change the formula to give me the minutes but that isn't working either. We are a 24 hour facility and need to use the dates but the times aren't calculating correctly. "Dave Peterson" wrote: Time (and dates) are just numbers to excel. =average(a:a) should work. Any chance that the times weren't enter correctly? SharonTraff wrote: I subtracted one time from another to get the HH:MM. Now I need to find the average of all the times. When I Average(range of times) I do not get an accurate time (I manually checked it by changing the HH:MM to straight minutes. Is there a way to average time in Excel? -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the average time?
So you want to ignore the dates and only use the times?
Maybe something like: =SUMPRODUCT(MOD(a1:a10,1))/COUNT(a1:a10) with a date/time in A1, this formula: mod(a1,1) will return only the time (format it nicely to check it) SharonTraff wrote: The times were entered as "12:36" etc., then as "9/13/06 12:36". I have tried to change the formula to give me the minutes but that isn't working either. We are a 24 hour facility and need to use the dates but the times aren't calculating correctly. "Dave Peterson" wrote: Time (and dates) are just numbers to excel. =average(a:a) should work. Any chance that the times weren't enter correctly? SharonTraff wrote: I subtracted one time from another to get the HH:MM. Now I need to find the average of all the times. When I Average(range of times) I do not get an accurate time (I manually checked it by changing the HH:MM to straight minutes. Is there a way to average time in Excel? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you average more than 30 time points in Excel | Excel Worksheet Functions | |||
Average Time Difference | Excel Worksheet Functions | |||
How to find number of hours past a spesific time | Excel Discussion (Misc queries) | |||
Find a time value in one column based on names in another | Excel Discussion (Misc queries) | |||
Funcation to average the Time spent | Excel Worksheet Functions |