What is Wrong with my Formula?!?

[mthrasher16]

Hi All,

I'm trying to make a pretty simple spreadsheet that calculates the time an employee works. All of my formulas are working fine except the most important one - this formula needs to be able to calculate the number of hours worked, regardless of weather or not time is put into the Lunch Start or Lunch End cells. (I have to do it this way to be able to tell how much time lapses between an employee punching in and their official start time. Otherwise I'd just do a much simpler formula where I keyed the length of their break in)

I think I'm close but keep getting a, 'There's a problem with this formula' prompt or a 'Too many arguments prompt.' Am I just stuck with a parenthesis is the wrong place or is my formula fundamentally flawed?

C15 = Time In
D15 = Lunch Start
E15 = Lunch End
F=15 = Time Out

This is my formula: =IFERROR(IF(COUNT(C16:F16=4),IF(F16<C16,1,(F16-E16)+(D16-C16)),IF(AND(LEN(C16)<>0),LEN(F16)<>0),IF(F16<C16,1,0+(F16-C16,0))*24,0

Thanks for your help!

 

[awoohaw]

Welcome to the forum! Does you day extend into the next day?

 

[mthrasher16]

Does you day extend into the next day?

No, never.

 

[awoohaw]

Maybe try this:
(if this is not what you want, please provide some examples)

Book1
	C	D	E	F	G
14	Time In	Lunch Start	Lunch End	Time Out
15	08:00:00	12:00:00	12:30:00	16:30:00	08:00:00
16	08:00:00			16:30:00	08:30:00
17	08:00:00		12:30:00	16:30:00	08:30:00
18	08:00:00	12:00:00		16:30:00	08:30:00
Sheet1

Cell Formulas
Range	Formula
G15:G18	G15	=IF(OR(D15="",E15=""),F15-C15,(F15-E15)+(D15-C15))

 

[mthrasher16]

Maybe try this:
(if this is not what you want, please provide some examples)

Book1
	C	D	E	F	G
14	Time In	Lunch Start	Lunch End	Time Out
15	08:00:00	12:00:00	12:30:00	16:30:00	08:00:00
16	08:00:00			16:30:00	08:30:00
17	08:00:00		12:30:00	16:30:00	08:30:00
18	08:00:00	12:00:00		16:30:00	08:30:00
Sheet1

Cell Formulas
Range	Formula
G15:G18	G15	=IF(OR(D15="",E15=""),F15-C15,(F15-E15)+(D15-C15))

Dude - that seems to work! I had to add a "*24" to the end of your formula so the 'hours worked' formatting would work, but I think you got it!

I was making it way more complicated than it needed to be - as usual. : /

Thank you so much for your help!

 

[awoohaw]

Happy to help. Best wishes!