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.

[email protected]
excel 2007

Hi

Have you got your 32hours 25mins as a number or formatted as time in the [h]:mm format.

Chris

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

this is your final warning! if i see you posting the same thread again i WILL ban you!!