MAKING A WORK SCHEDULE

P

Phil

Help Me!
I'm making a work schedule using this formula =INT((F6-E6)*24) to project
daily time.. This works great for the 8:00am to 5:00 pm shift , calculates 9
hours. I need a formula to project the half hour (IE 7:30am to 5:00pm or
7:00am to 5:30 pm) and give me 10.5 hours. I've also tried the formula
=text(b2-a2,"h:m"). This works for the daily time but can't get a formula to
add up total hours for all seven days of the week. A formula for either of
the problems will be great, though the first would be best.
TIA
Phil
 
D

Dave Peterson

Drop the =Int() portion:
=(f6-e6)*24



Help Me!
I'm making a work schedule using this formula =INT((F6-E6)*24) to project
daily time.. This works great for the 8:00am to 5:00 pm shift , calculates 9
hours. I need a formula to project the half hour (IE 7:30am to 5:00pm or
7:00am to 5:30 pm) and give me 10.5 hours. I've also tried the formula
=text(b2-a2,"h:m"). This works for the daily time but can't get a formula to
add up total hours for all seven days of the week. A formula for either of
the problems will be great, though the first would be best.
TIA
Phil
 

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

Top