Time Sheet Formula's please!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 31 Oct 2007 22:35 GMT

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=CT101
172771033

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.

Reply to this Message

Gord Dibben - 01 Nov 2007 00:14 GMT

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

>HELLO SMART PEOPLE!!!
>
[quoted text clipped - 16 lines]
>
>Thanks for any help you can provide. I really appreciate it.

Reply to this Message

Jeff - 04 Nov 2007 20:34 GMT

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

> Enter this in F14 and copy down.
>
[quoted text clipped - 28 lines]
> >
> >Thanks for any help you can provide. I really appreciate it.

Reply to this Message

Rate this thread: