I have myself a bit turned around with this time project. In a nutshell, I have built a sheet to track time. Once it is tracked it will come to this totals page.
When we have the total amount of time the employee will get paid for....It is based on 15 minute increments. If it is below 7 minutes, it goes back to 0.
If it is 8min-22 minutes it is rounded to 15min. 23-37 is 30min. 38-52 is 45min. Anything greater than 52 is added to the top of the hour. So, 4 hours and 55 minutes will
get paid for 5 hours.
I took this idea and formed a vlookup formula. But, I must admit I am totally lost. Any help with the formula or a better way to achieve this is greatly appreciated.