I have read so many how-to pages & posts, to no avail. I have created a simple time sheet that calculates time in & out, total time & total pay. All of it is working, except for the pay calculation; it will not calculate the cents for some reason. I have attached a sample sheet, but here is the formula I used: =IF(D11-C11=0, "",E11*E7). At present, it rounds it to dollars even though I have not used a function to make it happen.

Additionally, I would like for the total time to remain blank if there has not been a time inserted into both the In & Out slots. I tried several formulas, but never got them to work. Here is the formula I am currently using: =IF(D11-C11=0,"", (D11-C11)*24).

Any help is greatly appreciated!

Daily Time Sheet_Test.xlsx