Excel Reporting on daily & Monthly basis Categorically

Copper Contributor

Hello Excel Masters,

 

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.

0 Replies