How can I calculate daily hours worked minus lunch to eual a decim
 

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a decim
 

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time


=((D2-A2)-(C2-B2))*24

"lili" wrote:

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a d
 

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?



"Teethless mama" wrote:

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time


=((D2-A2)-(C2-B2))*24

"lili" wrote:

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a decim
 

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

On Mar 28, 12:00 am, lili wrote:
example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a d
 

"Pete_UK" wrote:

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

On Mar 28, 12:00 am, lili wrote:
example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a d
 

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time

=((D2-A2+(A2D2))-(C2-B2+(B2C2)))*24


"lili" wrote:

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?



"Teethless mama" wrote:

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time


=((D2-A2)-(C2-B2))*24

"lili" wrote:

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25

How can I calculate daily hours worked minus lunch to eual a d
 

You are one Freak'n GENIUS, Theethless
mama!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"Teethless mama" wrote:

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time

=((D2-A2+(A2D2))-(C2-B2+(B2C2)))*24


"lili" wrote:

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?



"Teethless mama" wrote:

Assuming
A2: start time
B2: Lunch out
C2: Lunch in
D2: End time


=((D2-A2)-(C2-B2))*24

"lili" wrote:

example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25