Time Card Calculates ALL possible shifts with Automatic Deduction of 30 min Lunch Time

[ShannaBanana]

Was hoping someone could help me?

I need to calculate all possible shifts with an automatic deduction of 30 min lunch time when the employee works 6 or more hours.

I have this formula so far:

Time in: A1
Time Out: B1
Total Hours: C1

A1 and B1 formated 1:30 PM
C1 formated 13:30

Formula: =IF(B1<A1, B1+1,B1)-A1

Now I just need to auto deduct 30 minutes for employees working 6 hours or more? Can anyone help with this last step?

 

[ShannaBanana]

Wonderful! Thank you so much! This works perfectly! Thank you so much and my apologies again for not being specific enough!

Thank you and everyone at my work thanks you for making their job easier!!!

 

[ShannaBanana]

WOW! This works perfectly! Thank you so much Tetra201 and FDibbins! Again, I apologize for not explaining myself in enough detail. Everyone at my work thanks you too for making their job easier!

 

[Tetra201]

You are welcome.

 

[FDibbins]

happy to help

 

[Guru008]

=IF(TEXT(J4-I4,"H")>6,(TEXT(J4-I4,"H")-0.5),TEXT(J4-I4,"H"))

I am able to respond in real time to you until it is solved!

 

[FDibbins]

Guru, you have been asked before, Im sure, but why bother to make a comment like that

=IF(TEXT(J4-I4,"H")>6,(TEXT(J4-I4,"H")-0.5),TEXT(J4-I4,"H"))

We all pretty much respond in real time