Ok, I see others in here have similar problems to me. I am trying to streamline the time sheets at work. I am looking at putting a formula in that: when hours worked = more than 35 that figure goes into the box below. I would also like to put dates into columns automatically rather than having week 1 week 2 etc. I'd also like to have negative munbers in the time in lieu box to be marked in a different colour. I know it must be quite simple, but I am new to all this stuff.
Thanks in anticipation.
Scattysample Employee timecard1.xlsx
Bookmarks