=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


"DannyJ" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> =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
>
>