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