HI, I am trying to creat the basics of a timesheet calculator for myself for work. This is not a school project and is strickly for personal use. But the premade templates dont have what I want. I am attaching a picture of my idea of just starting out how I am trying to calculate the cells with formulas. Once i figure out how to get the proper formulas I am going to make a monthly calendar out of it. If anyone could assist I would appreciate it. When I did somewhat find out the formulas in the cells in the top example when I go to copy the cells downward it doesn't do it properly.

Time sheet \begin{tabular}{|c|l|r|r|r|r|r|r|r|} \hline Date & Day & Start Time & End Time & Break Time & Total Time & Rate & Billable Amount \\ \hline 23-Jan-23 & Monday & 7:40AM & 4:30PM & 0:30 & 8:20 & $ & 22 & $183.33 \\ \hline 24-Jan-23 & Tuesday & 7:40AM & 4:30PM & 0:30 & 8:20 & $ & 22 & $183.33 \\ \hline 25-Jan-23 & Wednesday & 7:40AM & 4:30PM & 0:30 & 8:20 & $ & 22 & $183.33 \\ \hline 26-Jan-23 & Thursday & 7:40AM & 4:30PM & 0:30 & 8:20 & $ & 22 & $183.33 \\ \hline 27-Jan-23 & Friday & 7:40AM & 4:30PM & 0:30 & 8:20 & $ & 22 & $183.33 \\ \hline \end{tabular} I want it to look like this but cant figure ourt the formulas. Time sheet Where I can just change my break time to 45 min if I I do that day and then calculates the other colums Or If I change my start time and end times it will autojust the other colums as well