I have timesheet data collected from a fingerprint reader and have organized it in a pivot table on sheet 2 of the attached file.
I would like to get formulas in columns BA to BE for
Total hours worked
No of days counted
Average hours worked on each day
No of days worked less than 8 hours
whenever a time in as well as a time out is recorded.
In addition I would like to have a count of days present whenever there is at least one of time in and time out recorded.