tvschumann
New Member
- Joined
- Apr 16, 2002
- Messages
- 2
I am trying to convert minutes to a decimal, then take that decimal and convert it to money. If I take 00:56 and convert it to a decimal with the formula:
=(HOUR(A1)+INT((A1))*24+MINUTE(A1)/60)
I get 0.93. Then I take that Cell and multiply by the pay rate of $21.00 with the formula of : =B2*21 I get $16.60!!
0.93 x 21 = 19.53
I seems that only every third minute is correct, the others are off by .07 cents.
Any help with this problem would be greatly appreciated.
=(HOUR(A1)+INT((A1))*24+MINUTE(A1)/60)
I get 0.93. Then I take that Cell and multiply by the pay rate of $21.00 with the formula of : =B2*21 I get $16.60!!
0.93 x 21 = 19.53
I seems that only every third minute is correct, the others are off by .07 cents.
Any help with this problem would be greatly appreciated.