Hi: I have created Attendence sheet in Excel in which there is mention employee name, in time , out time and total hours and our office is open 24*7*365 so there is different shift working.Problem which is below.
1:- I want to add 3 columns one is ."Total days working, Total hours" need in the end of Month.
2:- How we can able to calculate it total days working or total hours. When i tried to use formula in attendence sheet it won't work.
3:- How colours will be set for PL, CL, week off so that if i mention PL then colour automatic change so on.