Timesheet calculation

[Dawn]

I am trying to create a simple time sheet that allows for
a number of INs & OUTs each day.

I used [=TEXT(B2-A2,"h:mm")] to calculate each instance within the day,
which can sometimes be up to 3 and accounts for lunch and a break
I am stuck at the how to create the end of the day calculation.

I appreciate any help that can be provided!

 

[Niek Otten]

Probably anything you need in timesheets can be found at

http://www.cpearson.com/excel/overtime.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel