| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
total hours worked for salary timesheet
Hi,
I need to add hours from a drop-down list to determine the number of hours worked minus 30-60 minutes(LUNCH), rounding to the quarter hour. Ex. IN OUT HRS 8:00 am 4:30 pm 8.00 G11 I11 K11 IN (G11) and OUT (I11) use a list of hours from another sheet, and HRS (K11) use the formula "=HOUR(I11-G11)". The listed hours are for easier user input, and I'm reformatting someone else's design. As long as I can get the HRS-LUNCH(rounded to 1/4 hour), I'm good! Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excell how can i get a total hours worked value from 2 times? | Excel Worksheet Functions | |||
| total Hours Worked for week PS thx for the formulars everyone! | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Timesheet hours will not total. Help. | Excel Discussion (Misc queries) | |||
| How to subtract a lunch break from total hrs worked in timesheet | Excel Programming | |||
Linear Mode
