Thread: FORMULA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann
 
Posts: n/a
Default FORMULA

Just take the =+ out of your formula

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"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.