Hello, I have a simple question, but I have been staring at it for so long I am stuck.

In regards to time cards, So if cell B3, is total hours for the week 53 hours, I need C3 to pull 40 and the remainder of 13 hours to pull into D3.

What Excel formulas do I use? Tried this =IF(B3>40,B3-40," ") but just pulls the OT number without subtracting the OT amount from B3.

Thanks!

message edited by KarlaZ

A formula in C3 cannotchange the data in any other cell,

it can only display the result of the formula.MIKE

Ask Your Question

Weekly Poll

Do you think Big Tech does enough to help make computing secure?

Discuss in The Lounge

Poll History