Self-calculating timesheets!

I work a 7hr30mins day. Is there any way that the overtime can be made to reflect any time over this.
http://www.excelforum.com/excel-work...imesheets.html

Originally Posted by mewingkitty

That's how we do our entry 'cause my manager hates typing :D

Here,
You can hide the columns on the right if they're going to confuse your guys, and you don't really need the morning and afternoon totals, but they're there cause that was the easiest way I could adapt mine to fit your 2 part day from the one I made for one part.

You can also change the week names to whatever you want if they're easier to follow that way. And our overtime is set to after 4 hours a day on weekends, not sure if that applies to you or not. Let me know if you need a hand changing anything else.

P.S.
Didn't have a lot of time to doublecheck anything, make sure you run the numbers manually once before assuming it's good to go!

Hello marion.h:

Here's a couple of web sites that might help.

http://www.cpearson.com/Excel/overtime.htm

http://www.mvps.org/dmcritchie/excel/datetime.htm