Excel Magic Trick 446: Time In & Time Out in Same Cell Bad Setup Leads To Complicated Formula

[kpdesignz]

Hi Like what you are doing, I have a project on Excel do you do freelance

[ExcelIsFun]

@kpdesignz , I do not. Sorry.

[kindrlmg]

can you please tell me how to do the calculations for someone taking lunch, so time in, out, in and out again?

[ExcelIsFun]

Try these videos:

Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaks

and

Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift...