So I have timesheet that is working pretty awesome however for data entry I want to be able to not have to use the Colon (:) when entering time. I figured how to do that, but it does not add my time up correctly when I changed it.
I currently use =MOD(C6-C5,1)*24 to add the hours up, and my...