XL stores times as fractional days (so 03:00 = 0.125). Since times roll
over at midnight, you have to add 1 (a full day) to the later time if
your values times spand midnight. You can use the fact that XL coverts
boolean TRUE/FALSE values into 1/0, respectively, in math functions:
A1: start time
B1: end time
C1: =B1 - A1 + (B1<A1)
Include the date with each time, so Excel knows you don't mean 10:00pm
Friday 5/13/05 to 6:00am Monday 5/16/05, etc etc..........then just subtract
as normal and format to suit.
Vaya con Dios,
Chuck, CABGx3
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.