Hi,

I am working on a worksheet where an email message will be sent if the time difference between two cells (two predetermined times) is greater than 30 minutes and lexx han 4 hours regardless of the start or end time.

Cols A and B contains the times (schedule) and Col C contains the difference.

The VBA code works perfectly for all values in Col C except for negative time differences which are displayed as #####.

Any way to get around this issue?

Best Regards
Ziad