How do i calculate the time between 10:00 pm and 6:00 am in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I working on a 2 week schedule for my employees. What i need to know is, how
do I calculate the time between 10:00 pm and 6:00 am in excel?
 
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)

or the more obscure but equivalent

C1: =MOD(B1-A1, 1)

See

http://cpearson.com/excel/datetime.htm

for more
 
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
 
Back
Top