Excel Reporting on daily & Monthly basis Categorically

%3CLINGO-SUB%20id%3D%22lingo-sub-2855991%22%20slang%3D%22en-US%22%3EExcel%20Reporting%20on%20daily%20%26amp%3B%20Monthly%20basis%20Categorically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2855991%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Excel%20Masters%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20one%20excel%20sheet%20where%20i%20want%20the%20following%20information%20in%20the%20report%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20many%20workers%20were%20there%20for%20a%20Particular%20category%20and%20on%20which%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEg.%20on%201st%20Nov%202021%2C%20There%20were%203%20%3CSTRONG%3EMason%2C%202%20Plumbers%2C%201%20Helper%3C%2FSTRONG%3E%20working%20at-site%20%3CSTRONG%3EWarqa%2C%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E2%20Electricians%2C%201%20Plumber%2C%20%3C%2FSTRONG%3Eworking%20at%20site%3CSTRONG%3E%20Dubai%20Hills%2C%3C%2FSTRONG%3E%20and%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20this%20on%20a%20daily%20and%20monthly%20basis%20and%20all%20this%20data%20will%20be%20coming%20from%20the%20sheet%20name%26nbsp%3B%3CSTRONG%3E(timesheet)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ESecondly%3A%26nbsp%3B%3C%2FSTRONG%3Ein%20the%20sheet%20named%20(timesheet)%20i%20need%20to%20calculate%20the%20overtime%20hrs%20which%20will%20be%20based%20on%20this%20calculation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDaily%20standard%20working%20hrs%20are%209%2C%20weekly%201%20day%20off.%26nbsp%3B%20so%20total%20weekly%20working%20hrs%20will%20be%2054%20Hrs%2C%20if%20someone%20has%20less%20than%2054%20hrs%20in%20a%20week%20OT%20hrs%20should%20be%20in%20minus%20and%20if%20it%20is%20more%20than%2054%20hrs%20a%20week%2C%20OT%20hrs%20should%20be%20surplus%20accordingly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2855991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional 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