=MOD(A2,1)*24-16 and format not as Date or Time but as General or Number, or
Custom Format such as +0;-0
--
David Biddulph

" wrote in message
...
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