Hmm... the hours are entered as proper time/format. For some reason it still
didnt to work. I got it to work in the end by just making a temporary column
in excel that had the data computed already. functionally works perfectly
now, just i wish it was fully automated. Thank you anyways for your time.

"OssieMac" wrote:

Before spending a lot of time on this because you suspect the comparison of
the Dates/times.

Are the Hours entered as proper times on the worksheet. If so then dimension
the Hours variable as a date and see what happens.

Time in VBA are in fact dates. (Just a fraction of a day.) and the variables
should be dimensioned as dates.

--
Regards,

OssieMac