Hi All

Please see attached file I have created to record Date & Time for a number of processes.

The process end time is entered using the DD/MM/YY HH/MM format.

When subtracting values, I am getting errors when the values have differing date values.

Cell J9 should result in a value of 101 hrs


Appreciate yr help with this one


Check Analysis.xls