IT Employment

General discussion


Excel Help Too....

By cassey.bearup ·
Can anyone tell me if it is possible to use a formula to calculate overtime (w/ overtime being anything over 40 minus holidays, vacations, etc...)?

I found a formula that works as long as there is overtime to report, otherwise, I get the "#####" error. If possible I would like the cell to show "0" rather than the error message if there is no overtime. I have tried using the IF function but I am either using it wrong or I am not understanding the IF function right.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

widen column?

by myakinhed In reply to Excel Help Too....

Sorry, I don't have an answer. Just wondered if ##### is really an error. Is it possible that you just need to widen the column to see the value?


Related Discussions

Related Forums