subtractct Lunch Time

[exc1967]

I have a formula on the attached workbook. It currently gives me the hours worked during the day. I need it to back out 30 minutes for lunch.

[ChemistB]

just add -0.5 to the end of the formula. You'll need to reformat the cell as general. Did that work for you?

[Kaper]

In other words, and referring directly to your workbook:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

And as ChemistB mentioned, remember to restore cell format to general because excel will notice you are working on a date/time cells and will set time format automatically

[exc1967]

Thanks, I wasn't formatting it to General.

[exc1967]

Now I have another issue that I didn't think about, when it crosses midnight this formula doesn't work.

[protonLeah]

(C2+(1*(C2<B2))-B2)*24-D2

1*(C2<B2) checks for midnight crossing

[exc1967]

Thanks Ben!