hi everyone,
i have raw data that is pulled out of a program that i need to clean up
the data comes out with times and dates of when an operated assign a task for each process

so operate add job on the 4/7/2012 at 06:30 but does move it to the next dept until 10:30
easy to work out that the time held with that operator was 4 hours
but have a problem when data carries over a day eg added at 17:30pm then not passed on to the
next dept till 09:00am the next day so the hours would be 15.5 hours but i want to eliminate the non working time
so the time held with operator would only really be 30min because work hours are 8.30am to 17.30pm....
Also there are blank cell that need to be handled

see attached for example of data
total cal.xlsx