Time Sheet Pay Calculation Issue

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

substitute this formula in your F column

Please Login or Register  to view this content.

I guess the calculation is correct...
9 hours one gets $ 108 and for the 10 minutes you get 1/6 of 12 which is 2. thus $110 even

for the next one the minutes equal to 5/60 or 1/12 so they add a full $1.00 to the hourly value.

the N() gives the number of a string.

add a minute to either one ...

Regardless of which formula I use, the total is not correct:

1) 8:10 AM 5:20 PM 9.17 $110.00
2) 7:45 AM 2:52 PM 7.12 $85.40

E: =IF(D11-C11=0,"", (D11-C11)*24)
F: =IF(COUNTA(C11:D11)<2,"",MOD(D11-C11,1)*24*$E$7)

1) total should be $110.04
2) total should be $85.44

Exact same thing occurs when i use the formula provided by rcm, as well as the formula i was using originally. I intentionally used examples that would not return even numbers to enable me to verify the results. I'm at a complete loss...

I see my error in the way I was calculating the cell; however, it is still not calculating properly to the exact cent. Please don't be annoyed with me, I'm really trying to understand.

Using my original examples from the attached spreadsheet:

8:10 AM 5:20 PM 9.17 $110.00
7:45 AM 2:50 PM 7.08 $85.00

Using long form so you see where I'm getting it from:

17/60 = .28 + 9 = 9.28*12 = 111.36
08/60 = .13 + 7 = 7.13*12 = 85.56

Kevin, I finally found the issue thanks to this link: Times.

Turns out the reason why my calculations did not match Excel was the way I had the E column formatted. I had it formatted as a number with 2 decimal places. I changed it to h.mm and the issue was resolved.

Now it displays as 9.10, which does indeed calculate to $110.00. Thank you for taking your time to help me think through this! :D