Richskelly
New Member
- Joined
- Dec 8, 2018
- Messages
- 4
Hi I am trying to create an overtime sheet for my Hospital's salaries department and I am stuck!
They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day.
Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be recorded (eg 09:00-17:00 and 19:00-22:00).
The time sheet makes us fill out each hour with an "x" for on site and an "o" for off site in a row of 24 boxes per day representing each hour of that day.
So what I need is, if there are 2 or 3 periods of onsite work per day (represented by a row of x's). can someone give me a formula to convert these to individual time periods in a box at the end of the row (eg 09:00-17:00, 19:00-22:00 and 23:00-00:00)
We currently have a time sheet which cant change in its appearance very much or they wont accept it.
PLEASE CAN SOMEONE HELP ME!!!!
They need to have an out put of the exact hours worked (eg 09:00-17:00) for each day.
Some people my work onsite in the hospital on several occasions per day so the exact hours for these need to be recorded (eg 09:00-17:00 and 19:00-22:00).
The time sheet makes us fill out each hour with an "x" for on site and an "o" for off site in a row of 24 boxes per day representing each hour of that day.
So what I need is, if there are 2 or 3 periods of onsite work per day (represented by a row of x's). can someone give me a formula to convert these to individual time periods in a box at the end of the row (eg 09:00-17:00, 19:00-22:00 and 23:00-00:00)
We currently have a time sheet which cant change in its appearance very much or they wont accept it.
PLEASE CAN SOMEONE HELP ME!!!!