Complicated Excel Formula

Microsoft Office excel 2003
May 11, 2010 at 01:29:24
Specs: Windows XP
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.

Many Thanks!

See More: Complicated Excel Formula

Report •

May 11, 2010 at 07:26:30
Post some examples of your data.
I'm curious, why are Dates & Times entered as numbers and not Dates & Times?


Report •
Related Solutions

Ask Question