I have a spreadsheet with around 50 peoples work hours, two of the columns are time in and time out, the workers start at different times, some start at 02:00 till 10:00 some start 02:00 till 06:00 and some start 04:00 till 10:00 ect ect, i'm having trouble finding a formula to find the hours between two times for example all the hours between 02:00 and 03:00 buy using the two columns of time in and out and was wondering if anyone could help?
thankyou in advance
Dave
thankyou in advance
Dave