1. ## Time and Labor Calculation help Please...

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

Code:
`=(INT(A2)+MOD(A2,1)*100/60)*A1`

3. Another way

=A1*SUBSTITUTE(B1,".",":")*24

4. Hi

It will be nice to browse forums, without seeing the same post on every forum!!

5. At least he hasn't duplicate posted here

6. Originally Posted by Bob Phillips
At least he hasn't duplicate posted here
I wish that wasn't so funny!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•