Tutorvo

Daywork Sheets: Clock Times, Breaks, Night Call-Outs & Quarter-Hour Billing

Lesson 3 of 816 minLab

This lesson is part of the course

In this lesson

You turn a week of start and end times into decimal hours worked, survive a night call-out that ends after midnight, round every entry up to the quarter hour for billing and total the billed hours for one worker with SUMIFS.

Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.

Lessons in this course

  1. Labour Burden: From Base Wage to Cost per Paid HourLab15 min Locked
  2. Billable Hours, Overhead & the Charge-Out RateLab17 min Locked
  3. Daywork Sheets: Clock Times, Breaks, Night Call-Outs & Quarter-Hour BillingLab16 min Locked
  4. Rate Tables, Overtime & Weekend PremiumsLab17 min Locked
  5. Materials on Daywork: Line Costs, Tiered Markups & MarginLab16 min Locked
  6. Service Calls: Minimum Charges, Travel Zones, Equipment Hire & Call-Out FeesLab17 min Locked
  7. The Weekly T&M Invoice: Category Totals, Billed to Date & a Not-to-Exceed CapLab17 min Locked
  8. Job Review: T&M Margin, Effective Rate, Fixed Price Comparison & a ChartLab18 min Locked