Excel Timesheet Formula

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

 

[Peo Sjoblom]

One way

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

if timespan exceeds midnight

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

 

[Norman Harker]

For Timesheets you might take a look at:

Chip Pearson:
http://www.cpearson.com/excel/overtime.htm
Gives formulas and there's a downloadable version available.

John Walkenbach:
http://j-walk.com/ss/excel/files/general.htm
A downloadable employee timesheet
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.