Thread
:
FORMULA
View Single Post
#
4
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
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.
Reply With Quote