I am trying to create one excel sheet where i want the following information in the report sheet.
how many workers were there for a Particular category and on which site.
Eg. on 1st Nov 2021, There were 3 Mason, 2 Plumbers, 1 Helper working at-site Warqa,
2 Electricians, 1 Plumber, working at site Dubai Hills, and so on
I need this on a daily and monthly basis and all this data will be coming from the sheet name (timesheet)
Secondly: in the sheet named (timesheet) i need to calculate the overtime hrs which will be based on this calculation.
Daily standard working hrs are 9, weekly 1 day off. so total weekly working hrs will be 54 Hrs, if someone has less than 54 hrs in a week OT hrs should be in minus and if it is more than 54 hrs a week, OT hrs should be surplus accordingly.