| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Average in Excel
How can i find a weekly average of a series of daily attendance log data
(e.g. Monday - 9.45 (H.MM) Tuesday-9.29 Wed- 9.40 Thu- 8.21 Fri- 9.00 in an excel sheet with a formula. What is the average hours I worked in this week? Plz help... Regards San |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Average in Excel
Enter the data as 9:45 (with a colon), not as 9.29 (with a decimal point).
Then just use AVERAGE(A1:A5) -- David Biddulph "Muthalaly" wrote in message ... How can i find a weekly average of a series of daily attendance log data (e.g. Monday - 9.45 (H.MM) Tuesday-9.29 Wed- 9.40 Thu- 8.21 Fri- 9.00 in an excel sheet with a formula. What is the average hours I worked in this week? Plz help... Regards San |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Average in Excel
Thank you such Mr. David! It works
"Muthalaly" wrote: How can i find a weekly average of a series of daily attendance log data (e.g. Monday - 9.45 (H.MM) Tuesday-9.29 Wed- 9.40 Thu- 8.21 Fri- 9.00 in an excel sheet with a formula. What is the average hours I worked in this week? Plz help... Regards San |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I calculate the average of a list of time values in excel | Excel Worksheet Functions | |||
| Average time | Excel Worksheet Functions | |||
| Using a time value in an Excel formula to figure an hourly average | Excel Discussion (Misc queries) | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| How do you average more than 30 time points in Excel | Excel Worksheet Functions | |||
Linear Mode
