Hi,
I have hours worked for employees listed over a monthly period. In the row below I have listed if they have worked their set number of hours for the month, more hours or less hours.
e.g one person has worked 420 hrs, which is their correct number of hours. The second person has worked 462 but their standard hours are 456, and the third person has worked 444 hrs but their set hours are 456.
Can someone please tell me what formula I can use to change the 6 hrs over, 12 hours under etc into days, based on the standard length of each day worked being 7 hours.
Thanks
Kat
I have hours worked for employees listed over a monthly period. In the row below I have listed if they have worked their set number of hours for the month, more hours or less hours.
e.g one person has worked 420 hrs, which is their correct number of hours. The second person has worked 462 but their standard hours are 456, and the third person has worked 444 hrs but their set hours are 456.
Can someone please tell me what formula I can use to change the 6 hrs over, 12 hours under etc into days, based on the standard length of each day worked being 7 hours.
Thanks
Kat