Timesheet Formula

  • Thread starter Thread starter ecrystal
  • Start date Start date
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.
 
Hi,

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

Thanks,

Daniel M.
 
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))
 
ecrystal said:
=((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
 
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
 
Back
Top