Over time formula needed

Over Time Explanation Hours Wrkd STO THO DTO
Completing contract 1 1.5 3
Completing contract 2 4 2 2
Completing contract 3 7 2 5

Totals 3 4 7

Not sure how to attach an Excel sheet now. Here is what I want. I enter my "hours worked" and the formula will automatically enter my time into the appropriate column. The "totals" part I can easily handle, it is the OT based on number of hours worked which I am having difficulty with.

Thanks for your help

Sorry, I am not sure how to attach and excel sheet and my attempts to put the columns in this post have been very abismal. The post does not keep my original formatting when I hit save.

Essentially I would like the sheet to move the over time from the "hours worked" column into the appropriate over time columns made up of STO, THO, and DTO columns. The columns would be arranged as follows:

Time Worked, STO, THO, DTO on the Excel sheet.

Hope that clears things up a bit

I have now attached an excel sheet showing what I am looking for, if possible. Thanks for all the help.

It works perfectly, but how do you count for zero? If you do not enter a value in the "hours worked" the balance for STO should be "0". Right now it calculates 3 hours for any value including 0. When you do not enter a value in the column it still shows 3 hours. I have attached your sheet with another example with a day when no OT was worked.

Thank you very much for your help. It works great. I really appreciate your assistance with this.

I have one more challenge. The second part of the Time Sheet (TS) has to do with making phone calls. Naturally some of them could be very short and other could last hours. I have attached the TS as far as I have gotten. You will notice I am attempting to be able to enter the times (C42, D42) and have the TS calculate the OT worked.

Paramaters:
Call up to 20 minutes = 0.5 hours at STO
Calls beyong 21 minutes = THO at exact minutes (which is why I am trying to list the times)

Is it possible to have the column E42-63 not display a "0"? That way the OT does not automatically populate F42-63 with 0.5 hours.

I have attached the TS for you to have a look at.

Thanks again,
Russ