Hi,
I have a spreadsheet that shows the schedule arrival time and actual arrival time of a product. I want to determine the difference between the 2 times (deviation) and determine if the product was early or late. It is early if it arrived before its schedule time (actual < schedule).
If the product arrives within an hour (late/early), it should be considered to be on time.
Please help me on how I can work out the formula to get the deviations (as illustrated on the last column)
I have a spreadsheet that shows the schedule arrival time and actual arrival time of a product. I want to determine the difference between the 2 times (deviation) and determine if the product was early or late. It is early if it arrived before its schedule time (actual < schedule).
If the product arrives within an hour (late/early), it should be considered to be on time.
Please help me on how I can work out the formula to get the deviations (as illustrated on the last column)
Thank you |