Formula does not work but why?

  • Thread starter Thread starter DannyJ
  • Start date Start date
D

DannyJ

=IF(August2005!I18>=TIME(15,,),E18=TIME(15,,),E18=August2005!I18)

This formula is part of a timesheet. 15 hours of overtime are allowed to be
carried over from one month into the next as time of in lieu.

This formula should be in English;- If the previous month has overtime
greater than or equal to 15 hours, then register 15 hours of carried over
time in cell E18, otherwise enter the actual amount of overtime in cell E18.

What happened was it returned the wrong values until I increased the
iteration....now it returns a value of "False". It should return the
overtime carried over from the previous month in hours and minutes.

Any ideas why?

Many many thanks for your help. My apologies that I will not thank you
later....my outlook express is behaving very strangely & reply group does
not work.

Danny
 
Danny

assuming that you are actually putting this formula in cell E18, try:

=IF(August2005!I18>=TIME(15,,),TIME(15,,),August2005!I18)

Regards

Trevor
 
Back
Top