|This might not be very complicated for the Excel Gurus out there, but I have run out of ideas.|
I have an Excel spreadsheet with the following information
Column D: Appointment Date
Column E: Appointment Time
Column F: Completion Date
Column G: Completion Time
Column H: Status
What I am trying to do is to create a formula to determine if Date and time in F & G are within a 3 hour window of date and time in D & E. If the date/time is outside that window indicate in column H whether it is early or late.
Please note that there is existing data in the tables and the data in columns are entered as numbers only and not formatted as time or date.
I would really appreciate if someone can help me with this. I spent whole day yesterday on this with no luck.