Hi, I am trying to create a basic time-tracking sheet for work. However, I just cannot seem to get it to work calculating the values, in the picture where you see the formula in the cells I just didn't put the "=sign" so you could see them but you should get the idea. I described more of what I am looking for in my picture.

I need firstly the correct formulas and would like the formulas to update the other cells if a value is changed in another cell in that row. Once i can get a basic weekly sheet created I will be making it into a larger scale and creating a monthly one.

2. For total time I would like it to calculate my total hours worked for the day by taking my End time subtracting my start time and then to minus the amount of time I took a break for because it is non billable. As you see in cell F3I am displaying the formula I have ( I just didnt put the equals sign so you can see it. In column G, I have displayed a rate of pay. In column H, I would like to calculate the toal amount made in that day. 3. Another user posted that I shoul use these formulas below: Total Time: = TEXT(HOUR(D3-C3),"00")\&":"\&TEXT(MINUTE(D3-C3),"00") Rate: =G14 Billable Amount: =F14*G14 - However the "total time" formula they provided does not subtract the amount of time I spent on break