Formula Required to Display Max Value

Hi Knowledgable peeps,

I am currently producing a flexi time sheet for my work.

Currently I have it set up but I need to factor in the following rules:

Colleagues may carry forward up to twelve hours credit and seven hours debit. No more than twelve hours may be credited – any remaining hours will be lost.

How i have it setup so far...

I have a running total that is cumualtive for the credit and debit hours.
This is worked out on the basis of a formula that looks at the total hours over/under the contracted per day hours - eg "if(a1>0...etc") - for credit hours and "if(a1<0..etc)" - for debit hours.

I now need to incorporate the above rules into this sheet somehow and this is where I am stuck.

Thank you.

BoB

Hi
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks for the prompt replies.
I have attached the actual sheet I am working on (if I have done it correctly)

Thanks
BoB

thanks for your reply.

It is the debit (Column S) and credit (Column T) I believe that I need to incorporate the rule in to so that no more than 12 hours is ever carried forward.

Thank you
BoB

On the flexi sheet tab

Try this
for Credit in S11

Formula:

Please Login or Register  to view this content.

For Debit in T11

Formula:

Please Login or Register  to view this content.

Sorry for last post #7
The formulas are

Formula:

Please Login or Register  to view this content.

Many thanks for taking the time to reply.

I have entered the second set of formulas that you kindly sent.
I have entered data to produce an excess of 12 hours over the contracted hours and the sheet is displaying a max of 4:48 and not counting past that for the credit hours.

Thank you
BoB

Try

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

See the file

thanks to all, that works
BoB