Excel help recording hours

Joined
Oct 27, 2013
Messages
1
Reaction score
0
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
 
Joined
Apr 12, 2014
Messages
4
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top