Timesheet hours throwing a #Value!

[jltjr75]

Searching has given me several ideas but it seems to not work for me.
I'm getting a #Value! while trying to "Total Hours"
Also "Hrs Worked" should be hours and minutes (not AM PM) and I don't want it to show zeros or 12 for blank start and finish times.
I think once I get the Total hours worked out I can get the "$20hr * Total Hours =" and the "plus travel pay ="

My Google Test Sheet:

test-contractor

time sheet Total Hours Pay Period:,June 28, 2021 - Jul 8, 2021,41:15:00,$20hr * Total Hours =,$825.00,plus travel pay = ,$890.00 Date,Day,Start Time,End Time,Hrs Worked,Location (Site),Miles Driven,Travel Pay,Total,Notes June 28, 2021,Monday,5:45 AM,6:50 AM,1:05:00,job 2,48,$15.00 June 29, 2021,...

docs.google.com

 

[jltjr75]

I'd like to thank JohnnyL, Toadstool, and Fluff for their quick support of my issues. It's been great learning through your inputs. Extra thanks to Toadstool for helping me in the past as well on excel sheets!!!