Time and Labor Calculation help Please...

tekkie4

New member
Joined
Jan 2, 2013
Messages
1
Reaction score
0
Points
0
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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Another way

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

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
At least he hasn't duplicate posted here :)
 
Top