Excel help recording hours

[caziscarol]

I have to work 39 hours per week. I have created a spreadsheet to calculate hours worked for the week.

To calculate the running total sometimes I am minus hours or plus hours. To create a full year planner with formulas I dont want to see -1555 hours when I havent even started using it yet. How can I format the cell to hide the value unless there are hours worked recorded for that week ?

Thanks

 

[chimpytech]

Have you tried setting a conditional format?

Setting it so that anything less than or equal to zero has the same background and font colour should work - the value will be there, you just won't be able to see it.

HTH

Neil