Excel Timesheet Formula

  • Thread starter Thread starter ECrystal
  • Start date Start date
E

ECrystal

I have a timesheet and I need it to calculate the time
between Start Work and TimeOut1, between TimeIn1 and
TimeOut2, and between TimeIn2 and End Work. 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.
 
One way

=EndWork-StartWork-((TimeIn1-TimeOut1)+(TimeIn2-TimeOut2))

if timespan exceeds midnight

=MOD(EndWork-StartWork-((TimeIn1-TimeOut1)+(TimeIn2-TimeOut2)),1)
 
Back
Top