IT Employment

Ask something
Discussion Locked

Excel Help Too....

0 helpful
1 reply

by cassey.bearup

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

by myakinhed

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?

myakinhed

This discussion is closed to new replies.