Hi

=IF(A117/24,A1-17/24,0)


--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)



"Bob Hoath" wrote in message
...
I have a time value in a cell (A1) formatted hh:mm. Say the value is
20:00.
In cell B1 I am trying to write a formula IF(A117:00,A1-17:00,0). This
should give me an answer 3:00 but I get error reports. I have tried
enclosing in brackets but to no avail. Any suggestions please?