Time Sheet Formula's please!

[Jeff]

HELLO SMART PEOPLE!!!

To be quite honest, I'm an idiot when it comes to Excel and I could use some
help (if possible.) The excel template I'll be refering to is linked to
here...

http://office.microsoft.com/en-us/templates/TC060888761033.aspx?CategoryID=CT101172771033

This is my issue. I'd like to be able to fill in the TOTAL HOURS WORKED
into the (Regular Hours) column and then have it automatically take out the
OVERTIME HOURS and put that into the appropriate column.

FOR INSTANCE... I type (10.5) hours into the REGULAR HOURS column (E) The
Formula subtracts the the overtime (2.5) and puts the overtime in column. (F)

I hope there's someone out there who sees where I'm trying to go with this.
I'm attempting to take the math out of this as some of the people we have
working here are NOT of the "rocket scientist" caliber.

Thanks for any help you can provide. I really appreciate it.

 

[Gord Dibben]

Enter this in F14 and copy down.

=IF(E14="","",E14-8)

Re-work L14 to this and copy down.

=IF(SUM(E14:K14)-F14>24,"You've entered more than 24 hours.",SUM(E14:K14)-F14)

Maybe change "Regular Hours" to "Hours Worked".


Gord Dibben MS Excel MVP

 

[Jeff]

I haven't tried this yet but I wanted to say a big THANKS for the help. I
appreciate the help of smart people!