I'm not very savvy with Google Sheets/Excel so I have been fumbling my way though attempting this. I'm trying to calculate amount of overtime pay for a given time worked. For instance: From hours 0-12, no OT pay. Hours 12:00-14:00 - a certain amount per hour. And finally from 14:00-16:00, a different amount per hour. I would like the cell to display the total amount of OT pay for the day. So if I work a 14:33 day, I'd like to know the total OT pay. I have the hourly rates for each segment in a reference cell, but for the life of me I can't come up with a formula that calculates what I need in a single cell. Any help is appreciated.