View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CS Project Man
 
Posts: n/a
Default 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