Forum Discussion
Overtime calculations based on different rates.
Good Morning, I need to create a spreadsheet to track hours worked and overtime, however each job worked could have a different base rate and a different time that overtime starts after. for example...
I need to be able to calculate the time between off duty (column n) at any location other than BI 128 (column m), and the on-duty time the next (column l) day if over 16:00 hours. if that makes sense. it's to calculate the time spent in a hotel (held away time). so a round trip is from BI 128 to BI 128 with a stop at any other location.
Does this do what you want?
=IF([@[Off Duty Time]]="BI 128",0,MAX(OFFSET([@Date],1,0)+OFFSET([@[On Duty Place]],1,0)-[@Date]-[@[Off Duty Place]]-TIME(16,0,0),0))
HansVogelaar, Yes that works great, Thank You - Matt