Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet Calculations
I have some freelancers that have submitted timesheets that don't match the
hours I have them worked. I can do it manually but is there a formula for the following? Time In minus Lunch, that total with Time Out equals Total time worked. Then the difference of Total time worked from Billed. Thanks! Worker Time In Lunch Time Out Total Billed Diff Bob 12:30 0:00 14:30 2:00 2.00 0.00 Jeff 12:30 0:00 14:30 2:00 2.00 0.00 Bob 10:00 0.5 17:00 6.50 10.00 3.50 Jeff 10:00 0.5 17:00 6.50 10.00 3.50 Bob 10:30 0.5 17:00 6.00 8.00 2.00 Jeff 10:30 0.5 17:00 6.00 8.00 2.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations based on PivotTable information | Excel Discussion (Misc queries) | |||
looping through a set of calculations | Excel Worksheet Functions | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
timesheet with running total of overtime | Excel Worksheet Functions |