total hours worked for salary timesheet

T

Tech_Student

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate hours worked minus lunch 4
Conditions on form calculated textbox 3
timesheet problem 0
Question about a formula for time .. 3
Graph usage for times of day 0
Calculating Time Worked in Timesheet 6
calculate hours using start time & end time, excluding weekends 5
adding the total hours worked in 5 weeks 2

Top