If the values are excel time values like 8:30 etc

=IF(J4F4,(J4+K4)-(F4+G4)-(14.5/24),(J4+K4)-(F4+G4))

if decimal values like 8.5

=IF(J4F4,(J4+K4)-(F4+G4)-14.5,(J4+K4)-(F4+G4))

having said that, what are in F, G, J and K?

Are you subtracting hours worked after midnight?

=MOD((end-start)-(in-out),1)

or

=end-start+(startend)-(in-out)


where end is end of work, start is start of work, in is end of break and out
start of break


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"TLAngelo" wrote in message
...
I am trying to create a formula that will subtract 14.5 hours from the
total
hours in one cell if the date in cell J4 is greater than the date in cell
F4.
Can anyone help?

Here is what I was trying, please don't laugh, I'm pretty new at excell :)

=IF(J4F4,=+(J4+K4)-(F4+G4)-14.5,=+(J4+K4)-(F4+G4))

Note: =+(J4+K4)-(F4+G4) is the formula that is calculating the total that
I
want to subtract 14.5 hours from.