Time Average in Excel

M

Muthalaly

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
 
D

David Biddulph

Enter the data as 9:45 (with a colon), not as 9.29 (with a decimal point).
Then just use AVERAGE(A1:A5)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the Weekly Daily Average 2
Excel, a sum for calculating the average spend 1
averages in excel 1
Formulas--NEED HELP! 4
Sum(indirect(Address...... 3
Excel Time Sheet For Employees 6
Need to Sum Mon-Sat each seven days; Average Sunday 7
calculating hours in one cell 2

Top