I've been plugging away at a self adding timesheet all morning, and it's driving me insane. :o
It's on a 24 hr clock, and it needs to let people carry over their hours below or in excess of 35 to the following pay period.
The minus hours are cauing the problem, so I found a little bit of code in a reply to somebody elses problem which might help:
=IF(A1>B1,"-"&TEXT(B1+1-A1,"h:mm"),B1-A1)
Please can you explain what each bit of this means so that I can apply it to my own problem?
Oh, and can I use a figure that comes out of this as a basis for another time based calculation?