How about this:
Code:=(INT(A2)+MOD(A2,1)*100/60)*A1
Hi Friends
I need help in couple of issues.
A1 has Hourly Bill Rate: 72.00 - formatted as Number
B1: has No of hours Billed: 32.25 ( 32 Hours 25 mins) - - formatted as Number
C1: Total Cost: A1*B1 - - formatted as Number
Here is the problem:
C1 (A1*B1) = 2322.00 (72*32.25)
But it is supposed to be 2334.00
Explanation: 72*32 hours = 2304 & if we divide 72/60 then 1.2 per minute. so 25min * 1.2 = 30 - - -final cost: 2304+30=2334.00
help me formula for excel formaula as well as Userform form formula.
tekkie4@yahoo.com
excel 2007
How about this:
Code:=(INT(A2)+MOD(A2,1)*100/60)*A1
Another way
=A1*SUBSTITUTE(B1,".",":")*24
Hi
It will be nice to browse forums, without seeing the same post on every forum!!
http://www.excelforum.com/excel-gene...lp-please.html
At least he hasn't duplicate posted here![]()
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks