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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Timesheet Formula 1
Timesheet Formula 4
Data timesheet makeover 4
Calculating Overtime in Access 5
Time calculations 6
Timesheet 2
Bonus/Absence/Timesheet workbook help needed. 6
Excel Timesheet Formula for Excel 1

Back
Top