L
lili
example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25
=13.25
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time
=((D2-A2)-(C2-B2))*24
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time
=((D2-A2)-(C2-B2))*24
L
lili
This only works for AM times. If I want it to work for PM starts I have to ad
24.
How do I work it all into one formula that will work for both?
24.
How do I work it all into one formula that will work for both?
P
Pete_UK
Assuming your times are in A1 to D1, then try this:
=(D1-C1+B1-A1)*24
Format the cell as number with 2 dp.
Hope this helps.
Pete
=(D1-C1+B1-A1)*24
Format the cell as number with 2 dp.
Hope this helps.
Pete
L
lili
Pete_UK said:Assuming your times are in A1 to D1, then try this:
=(D1-C1+B1-A1)*24
Format the cell as number with 2 dp.
Hope this helps.
Pete
T
Teethless mama
Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time
=((D2-A2+(A2>D2))-(C2-B2+(B2>C2)))*24
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time
=((D2-A2+(A2>D2))-(C2-B2+(B2>C2)))*24
L
lili
You are one Freak'n GENIUS, Theethless
mama!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
mama!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!