| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculation For A Timesheet To Include Lunch
Assume cell A1 has time in, B1 has time out, and C1 has the number of
hours (not minutes) for lunch. The formula would be: =HOUR(B1)-HOUR(A1)-C1 If you want to track lunch in hours and minutes, I think there's a minute function out there (did not test). HTH, Johnny |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| Please help with time calculation | Excel Discussion (Misc queries) | |||
| The shortcut to enter time in excel should include seconds. | Excel Discussion (Misc queries) | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
| Excel - Time calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
