I'm working on a kind of timesheet for my company, the problem is we have three shifts and so three different starting/ending hours.
First shift starts at 7:00 AM, second at 3:30 PM and third at 12:00 AM.
The timesheet I would like to create is that you just write down when someone started to work and when he ended his work, then Excel should automatically calculate how many hours someone worked, if someone worked overtime (worked over 8 hours a day) and if someone worked at night (from 10:00 PM to 6:00 AM). If someoneworked during night Excel should write down how many hours. And if someone worked overtime AND during the night Excel should write down how many hours were worked overtime and how many hours during the night seperately.
I managed to write formulas to calculate how many hours someone worked and how many hours were worked overtime.
My problem is to calculate the work done at night and to write overtime and night work seperately.
Here's a link with a picture for easier understanding:
http://pokit.org/get/img/0636feded4b...bad90e833f.jpg
Bookmarks