Excel document with working hours formula
Budget: $20 – $30 SGD
I want to make an excel doc that will be:
1. Day
2. Month/Date
3. Start work hour
4. End work hour
5. Total worked work
6. Total worked hours in a range of 22:00 - 00:00
7. Total worked hours in a range of 00:00 - 04:00
8. Total worked hours in a range of 04:00 - 06:00
MENTION:
A. Columns 1-4 are input columns, so data will be written manually.
B. Start and end work hours can be any, there is no regular work day, it's work hours, times can be 5 hours a day, some times can be 22 hours.
C. Columns 5-8 need to be calculated with formula
1. Day
2. Month/Date
3. Start work hour
4. End work hour
5. Total worked work
6. Total worked hours in a range of 22:00 - 00:00
7. Total worked hours in a range of 00:00 - 04:00
8. Total worked hours in a range of 04:00 - 06:00
MENTION:
A. Columns 1-4 are input columns, so data will be written manually.
B. Start and end work hours can be any, there is no regular work day, it's work hours, times can be 5 hours a day, some times can be 22 hours.
C. Columns 5-8 need to be calculated with formula