View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Help with a formula

Yes you're quite correct now that I read what the OP wrote again.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Pete_UK" wrote in message
ups.com...
Shouldn't this be:

=MIN('May 3'!M17,Time(15,,))

?

The carry-forward time shouldn't exceed 15 hours, even if 'May 3'!M17
does.

Pete

On Feb 14, 7:13 pm, "Sandy Mann" wrote:
Try:

=MAX('May 3'!M17,Time(15,,))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

"Josh UK" wrote in message

...



Please help: I'm not very good with formulas.


=IF(('May 3'!M17)<15,"15:00:00","(May 3'M17)")


May 3 M17 represents hours to carry over from the previous sheet/period
to
this period. This could sometimes by negative.


The rule is that you can only ever carry over 15 hours into the next
month.
The formula above needs tweaking as it still shows 15:00:00 even if the
value
in the previous sheet is less than 15:00:00.


Im using 1904 date format and [h]:mm:ss format.- Hide quoted text -


- Show quoted text -