Timesheet Formula

[ecrystal]

=((D6<C6)+D6-C6+IF(D7="",,(D7<E6)+D7-E6)+(F6<E7)+(F6-E7))

I have a timesheet and I need it to calculate the time
between Start Work (C6) and TimeOut1 (D6), between TimeIn1
(E6) and TimeOut2 (D7), and between TimeIn2 (E7) and End
Work (F6). Sometimes TimeOut2/TimeIn2 are blank fields,
but if they have time entered in them, I need them to
calculate. Right now they won't. The IF statement I
wrote bombs when I try and calculate the difference
between TimeOut2 and TimeIn1. Can anyone help? I'd
greatly appreciate it. Thanks in advance.

 

[Daniel.M]

Hi,

DO NOT post the question twice.
Follow up in the same initial thread.

Thanks,

Daniel M.

 

[Steve S.]

I'm not sure if this is doing what you are requesting, but
it implies that the employee is taking a lunch. If this
needs to be a possible option, place the additional IF
statement after the first comma and use the basic form of
this equation. This works if the employee is required to
have a lunch. (references based off your cells)
=IF(ISBLANK(D6),(D7-C6)+(F7-E7),(D6-C6)+(D7-E6)+(F7-E7))

 

[RAC]

=((D6<C6)+D6-C6+IF(D7="",,(D7<E6)+D7-E6)+(F6<E7)+(F6-E7))

I have a timesheet and I need it to calculate the time
between Start Work (C6) and TimeOut1 (D6), between TimeIn1
(E6) and TimeOut2 (D7), and between TimeIn2 (E7) and End
Work (F6). Sometimes TimeOut2/TimeIn2 are blank fields,
but if they have time entered in them, I need them to
calculate. Right now they won't. The IF statement I
wrote bombs when I try and calculate the difference
between TimeOut2 and TimeIn1. Can anyone help? I'd
greatly appreciate it. Thanks in advance.

I tried this and it worked for me
=(D6-C6)+(D7-E6)+(F6-E7)

RAC

 

[ecrystal]

I tried all of the suggestions that you all gave, and got exactly what
needed:
=IF(ISBLANK(D7),((D6<C6)+D6-C6+(F6<E6)+(F6-E6)),(D6-C6)+(D7-E6)+F6-E7)
The ultimate key was ISBLANK. Thanks a million for all you
suggestions