Thread
:
Help with a formula
View Single Post
#
5
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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 -
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann