There are lots of gotchas here that need to be clarified.
For one, are the time windows and percentages always the same? i.e. 00:00-09:00 = 150%; 09:00-17:00 = 100%, 17:00-00:00 = 150%?
Are you looking for the spreadsheet to calculate how many hours fall into each of those categories? Or are you relying on the individual/manager to fill regular hours vs. higher hours on different rows? (i.e. if someone worked 12:00-20:00, do you want the spreadsheet to calculate 5 hours @ 100% + 3 hours at 150%?, or would these be entered separately?)
Does any given shift start, end, or cross midnight? (date/time calculations can get really gnarly when this happens)
Do you already have the shift duration calculations working in the above sheet? or were those numbers entered manually?
Finally, are you sure this is how you want to present the timesheet?
At the very least, it may be confusing (either to the individual or to an auditor) to see someone work 12 hours a day (8 hours @ 150%). It may even be illegal in some places/professions.
It may be clearer to sum 'regular hours' and 'extended hours' separately rather than just multiply out the extended hours. In the above example, this individual's timesheet would report 6h 38m worked, which is not true - that may be what they're getting paid for, but that's not the same as hours worked.
That said, the initial ask is pretty easy - assuming you put either 100% or 150% in the % column, just multiply the Total Hours cell by the % cell:
=(H12-G12-I12)*F12
You can make it a little neater by assuming 100% unless there's something else in the % column:
(H12−G12−I312)×IF(ISBLANK(F12),1,F12)
Now if the % column is blank, it assumes 1 (or 100%), otherwise it multiplies by the percentage in that cell.
