Re: Timesheet with Night shift Calculation
First of all thank you all for the promt response with some solutions. It will be really great if you help me to modify these things. To be honest I tried it by myself but couldn't get it done. I have attached the orginal timesheet with it I will n't get confuse about the cell #.
The first sample I got is quite
Actualy I really don't need any extra columns. Is it possible to make it without extra column? If we must add columns then we can use it in the last area (In the attachment I wrote it 1/2/3/4/). So it will be easy to hide. Actualy it is my company corporate timesheet and I cann't change anything on it's design.
1> Total/Regular hours means the hours after deducting all break times.
2> If someone go to dinner at 1815 than the 15 minutes should deduct from the Day hours and add to night hours. Because he works 15 minutes and after 1800hrs it is night.
3> It should n't be always 8 hours regular. It depends on time. If some one work from 16:00 to 04:00 than day time should be 2 and night hours should be 6 and the rest is overtime.
So anyone has solution for me? I would like to thank you in an advance.
Last thing I would like to add that this is my first time using this website and really get great impression of it. Thanks for the webmaster as well.
Video Tutorials / Excel Dashboards Reports