Hi I need a formula that will compare a time against a given reference
time of 16:00. For example 13:00 would return -3 and 18:00 would
return +2
The comparison time is formatted ddd hh:mm as it is part of a weekly
planning sheet but I need to check progress every day against a
reference time of 16:00

Hope thats clear

Martin