IF Statements - to include calculation?
Thank you!
"Dave Peterson" wrote:
6 hours is 6/24 of a day. The whole number 6 would represent 6 days.
So try:
=IF(O3-N3<=6/24,O3-N3,O3-N3-$U$1)
or
=IF(O3-N3<=.25,O3-N3,O3-N3-$U$1)
or
=IF(O3-N3<=time(0,6,0),O3-N3,O3-N3-$U$1)
or even
=IF(O3-N3<=.25,O3-N3,O3-N3-time(0,30,0))
MissPiggy wrote:
I am trying to apply a function that works out the time worked, and then if
below 6hrs display as time, or if over six hours - deduct 30 mins before
displaying the time.
The feeder cells have been formated to time and it all seems to work - apart
from deducting the 30 mins. Here is what I have used (well one of many
attempts!)
=IF(O3-N3<=6,O3-N3,O3-N3-$U$1) [where U1 is a time cell containing 0:30:00]
Any ideas?
--
Dave Peterson
|