Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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/te...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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
hiding huge formula's in an excel sheet | Excel Worksheet Functions | |||
Removing Formula's from Copied Sheet | Excel Discussion (Misc queries) | |||
Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
how do I protect formula's only, not entire sheet or book? | Setting up and Configuration of Excel | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) |