Hi All,
I'm new the excel so please be patient, I have created a worksheet that shows the start and finish by worker, I am trying to establish what hours each worker has done per day, this is ok when a worker is on a day shift (eg 11:30 to 23:30) I can just minus the later from the first.. My problem is when a worker has done a night shift and is working (23:30 to 05:30) I don't use date just time example i imput as displayed in the thread, not 25/06/2012 23:30 to 26/06/2012 05:30, i hope that someone can help me as i can't be using the format mentioned as a manual entry everytime.......
Bookmarks