I am kind of new with excel. I have developed a weekly time sheet. in the Cell H, I have it to where it totals per day hours, exe) 8:45(h.mm), I would like to add a cell I to automatically notice that after 8 hours to put in the overtime hours after 8 hours into cell I.
Also, weekends are automatic overtime.
Does anyone know what kind of funtion to put into to achieve this.
Thanks, wish I had found this forum a couple of days ago, I was going nuts with a certain funtion and took me 2 days to figure it out!
This message was edited by Mitch on 2002-02-23 14:38
This message was edited by Mitch on 2002-02-23 15:01
Also, weekends are automatic overtime.
Does anyone know what kind of funtion to put into to achieve this.
Thanks, wish I had found this forum a couple of days ago, I was going nuts with a certain funtion and took me 2 days to figure it out!
This message was edited by Mitch on 2002-02-23 14:38
This message was edited by Mitch on 2002-02-23 15:01