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
Click to expand...
 

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

Work Budget Salary vs Real Time Salary 0
Calendar 2
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
work schedule formla's 2
Add time when working 3rd shift 0
Make peak values move to low value region - Peak Lopping - HELP! 0
Convert times to text string 3
Calculating tiome between 17 PM and 6 AM 23

Top