E
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.
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.