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
Bookmarks