- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel formula help
Posted on 1/20/14 at 8:56 pm
Posted on 1/20/14 at 8:56 pm
I'm trying to set up a page that I can enter employees time in/out on and it calculates the number of hours worked minus the 30 minutes taken out for lunch. I haven't used Excel to figure time before and I need help.
I enter their time in in cell A2 and the time out in B2. I set up cell C3 as the Total number of hours worked and so far I have (B2-A2) but cant get the formula to subtract the 30 mins.
I enter their time in in cell A2 and the time out in B2. I set up cell C3 as the Total number of hours worked and so far I have (B2-A2) but cant get the formula to subtract the 30 mins.
12
Posted on 1/20/14 at 8:59 pm to NatalbanyTigerFan
30 minutes for lunch, huh? Don't be such a pushover
Posted on 1/20/14 at 9:00 pm to NatalbanyTigerFan
=B2-A2-.5
Posted on 1/20/14 at 9:01 pm to NatalbanyTigerFan
=b2-c2-.5
=B2 - A2 - .5.
=B2 - A2 - .5.
This post was edited on 1/20/14 at 9:03 pm
Posted on 1/20/14 at 9:01 pm to NatalbanyTigerFan
D2= C2-0.5
Posted on 1/20/14 at 9:02 pm to NatalbanyTigerFan
quote:
I set up cell C3 as the Total number of hours worked and so far I have (B2-A2) but cant get the formula to subtract the 30 mins.
Set up all cells for time, subtract 0.5 hours. Or :30.
If you cannot make that work, make column 'd' 'c2-:30 (or 0.5)' and then just hide column 'c'
This post was edited on 1/20/14 at 9:03 pm
Posted on 1/20/14 at 9:02 pm to NatalbanyTigerFan
=sum (b2-a2)-.5
Posted on 1/20/14 at 9:02 pm to NatalbanyTigerFan
If time is in hours, (b2-a2)-.5
Make .5 30 if in minutes.
Make .5 30 if in minutes.
Posted on 1/20/14 at 9:03 pm to Hopeful Doc
Thanks to all 
I knew it had to be something simple. 
I knew it had to be something simple. 
Posted on 1/20/14 at 9:08 pm to NatalbanyTigerFan
(B2-A2) - TIMEVALUE("00:30:00")
Posted on 1/20/14 at 9:10 pm to NatalbanyTigerFan
quote:
I'm trying to set up a page that I can enter employees time in/out on and it calculates the number of hours worked minus the 30 minutes taken out for lunch. I haven't used Excel to figure time before and I need help.
I enter their time in in cell A2 and the time out in B2. I set up cell C3 as the Total number of hours worked and so far I have (B2-A2) but cant get the formula to subtract the 30 mins.
I have no idea what line of work you are in, but the correct timekeeping method should record the specific 30 taken for lunch.
Wage and Hour does not look kindly on employers automatically deducting a lunch break.
Posted on 1/20/14 at 9:13 pm to Evolved Simian
What is Wage and Hour?
Posted on 1/20/14 at 9:14 pm to NatalbanyTigerFan
y=mx+b
Posted on 1/20/14 at 9:16 pm to Martini
quote:
What is Wage and Hour?
Depends on the craft and experience.
I don't make the rules, the company does. Contract states that employees get a unpaid 30 min lunch break.
Posted on 1/20/14 at 9:49 pm to Martini
quote:
What is Wage and Hour?
The gubment
Posted on 1/20/14 at 10:12 pm to NatalbanyTigerFan
I am disappoint you couldn't figure this out on your own.
Posted on 1/20/14 at 10:14 pm to NatalbanyTigerFan
So how Mexicans do you have cutting grass for you?
Posted on 1/20/14 at 10:32 pm to NatalbanyTigerFan
It's just that you have to document exact time they punch out for lunch and then back in to work
They frown on you just auto deducting for 30 min
Probably will never be an issue but if you ever get audited. You will wish it was all in order
They frown on you just auto deducting for 30 min
Probably will never be an issue but if you ever get audited. You will wish it was all in order
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News