Share via

Overtime formula

Anonymous
2025-01-13T13:27:43+00:00

I'm filling out a payroll excel sheet, I would like to show "0" in the OT cell if the total worked hours do not exceed 44 hrs. Right now, I'm doing =sum(C10-44) which is giving me the number but if less than 0, I'd like to show a 0, can anyone help?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-13T14:46:36+00:00

    Hi, Fernanda Agata

    I'm glad to have helped you out, perhaps you could help me by marking a “yes” for helpful replies and then I'll close this thread, thanks for your understanding and cooperation!

    Best wishes

    Aiden.C - MSFT |Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments
  2. Anonymous
    2025-01-13T14:27:09+00:00

    Thank you so much! It worked perfectly.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2025-01-13T14:14:06+00:00

    Hi, Tanya Dawes

    Thank you for using Microsoft products and posting them to the community.

    You can use this formula:

    =MAX(0, C10-44)

    If the result is less than 0, it returns 0.

    I hope the above information can help you. Feel free to send a message if you need further help.

    Best wishes

    Aiden.C - MSFT |Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments