Calculating time help?

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

hopefully the excel sheet will help, i uploaded it. what it is, is cell G14 has the total and would like the remainder to go to C15

you can use min and MAX to find show 40 or less for PTO and 0 or more for OT

PTO

Formula:

Please Login or Register  to view this content.

OT

Formula:

Please Login or Register  to view this content.

see also attachment

You can use this in G14:
=MIN(5/3,SUM(G3:G13))
Formatted as [h]:mm

and this in C15:
=MAX(SUM(G3:G13)-5/3,0)
Formatted as [h]:mm

Awesome, I didn't think to try that

thanks for the help!

You're welcome. Happy to help.

Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Error post, sorry.