Should plugging in the formulas to this (see attached) spreadsheet be relatively simple? My friend tried to help me and I haven't figured out how close she came. I know that she made modifications I didn't ask her to make,.... she meant well. Eastern Effects is the original and mac212 is the modified with formulas plugged in.

My rates are usually based on 10 or 12 hour days. If I "beat the rate", it's because I worked less than the agreed upon base rate. $2 was just for example. When I drive to a location, that is my Start time. The Call time is my time that I am supposed to arrive at the location. Wrap is when we finish shooting,... a.k.a. Camera Wrap. When we finish packing the truck, "walk away" or get back to the hotel, city, etc. t.b.d,... that's when we are Out. I'm Back at the parking lot and that is when I go off the clock.

OT = 1.5
Dbl = 2.0

Normal or Straight = 10 or 12 hours

OT = 1.5 for the first 2 hours

Dbl = 2.0 until ,.... ???? hours after.

Maybe I should have one sheet for 10 hours days and one for 12 ??

Thanks for the reply.