| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
| Auto Calculation Automatically Turns Off???? | Excel Discussion (Misc queries) | |||
| time-clock calculation | Excel Worksheet Functions | |||
| time-clock calculation | Excel Worksheet Functions | |||
Linear Mode
