Thread: Cunstom time sheet.

Hello.

I am developing a time sheet and i want a feature that will indicate the average hours worked per day. The first column is the date and then there is the start time, break and end time and then the total hours worked. It would be relatively easy to average the time over a set 20 days, except that i don't work every day. How do i add up the total hours and divide by the total number of populated cells? Thanks.

Do you mean this array formula

=AVERAGE(IF(D2:D20>0,D2:D20))

I dont think so. I tossed it into the sheet and attached it. Feel free to take a look.


timesheettest.xlsx

You have to array-enter that formula, but with that data you can simply use

=AVERAGE(E2:E15)

Wow, i guess that is a classic case of me not trying it myself first. I assumed it would include the blank cells in the average. Thanks.