Timesheet calculation
 

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!

Probably anything you need in timesheets can be found at

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Dawn" wrote in message
...
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!