I am trying to make an ovetime calculator that sums up the number of hours between two dates and two times. That's pretty easy - the hard part is the conditions I have. I have a table on how many minutes count as a decimal. So every 6 minutes = .1 added to the time. If you don't make it to the next 6 minute interval (10 minutes) then you have to remain at .1

I am looking for a formula to incorporate my conditions to be able to get the proper overtime number I am looking for.

An example is included.

Thanks for the help.

Overtime Calculator.xlsx