Results 1 to 3 of 3

Thread: the difference between 2 times

  1. #1

    the difference between 2 times



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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)
    Schedule Arrival Time Actual Arrival Time Deviation
    11:00 14:00 3:00 (Late)
    15:00 10:00 5:00 (early)
    16:00 15:00 1:00 (On time)
    15:00 16:00 1:00 (on time)


    Thank you

  2. #2
    Try

    =TEXT(ABS(B2-A2),"hh:mm")&IF(ABS(B2-A2)*24<1," (on time)",IF(B2-A2>0," (late)"," (early)"))

  3. #3
    Perfect...

    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •