Comprehensive Work Hours Excel Spreadsheet
Budget: $30 – $250 AUD
I need a professional who's great with Excel to develop a worksheet that helps me track my employees' work hours over a 6-day week for a period of 26 weeks, divided into four-week periods. Your accurate and automated solution should:
- Calculate the total hours worked per day
- Monitor accumulated work hours over set periods
- Seize any work exceeding the daily contract hours of 7.6 hrs as banked hours, which should be displayed separately
- Have a dedicated column for used banked hours
- Allow every Saturday's contributions towards banked hours
Data should be easily enterable in hours and minutes format and calculated on entry. Also, the system should set up a rule to automatically reduce the total number of banked hours when some are used.
The ideal freelancer for this job would be proficient in Excel and have a strong background in HR, or time management systems. Exceptional attention to detail is a must, given the precision required for this task.
- Calculate the total hours worked per day
- Monitor accumulated work hours over set periods
- Seize any work exceeding the daily contract hours of 7.6 hrs as banked hours, which should be displayed separately
- Have a dedicated column for used banked hours
- Allow every Saturday's contributions towards banked hours
Data should be easily enterable in hours and minutes format and calculated on entry. Also, the system should set up a rule to automatically reduce the total number of banked hours when some are used.
The ideal freelancer for this job would be proficient in Excel and have a strong background in HR, or time management systems. Exceptional attention to detail is a must, given the precision required for this task.