=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(IF(I56,I5-0.5,I5)/24)))



--
Regards
Dave Hawley
www.ozgrid.com
"Jeff Brown" <Jeff wrote in message
...
I have a formula and can not make it work the way I would like.
=IF(H5="P",G5+12-F5,IF(H5="A",G5-F5,(I5/24)))) here it is.
I need it to subtract .50 from I5 if I5 is greater then 6.00