I work flexi-time in a 4 week cycle. I can be above or below at the cycle end by +/- 5 hours. Mostly I am in deficit. I want to create a spreadsheet that adds my carry over deficit to the hours I've worked this month, but excel doesn't seem to add negative times. I either get a #value! error message or the cell remains blank (although it shows a figure if my carry over is in the black. Any help would be appreciated.
I did a time sheet for the job i was doing last year... the bodge way round it is to record the actual hours you do, then total them up and use an =IF to say whether you are over or under. Something like (for a 160 hour month, 4x40hr weeks, with the total hours cell labelled "totalhours") :
Um, i think this checks out... not used Excel for a while so I'm happy to be told it won't work... I believe it should give you a positive number if you are over the hours (eg 5 for 165) and a negative for being under (eg -5 for 155).
Good luck - don't work too hard!
This thread is now locked and can not be replied to.