Time format hh,mm total to convert to regular number

[Calvin Zwaan]

I have a total of hours worked by all employees in a column and wish to use that same number to multiply by $15 per hour (eg. 2629:15 in hh,mm format - convert to 2629.25). Currently I just type the number manually, is there a formula that will convert this? Thanks

 

[Anthony47]

Hi Calvin,
just multiply the hh.mm frmatted data by 24 and then by the hourly cost:
=A1*24*15 (if the hours are in A1).

Bye,

 

[Richard Schollar]

=A1*24

Assuming your total hours is in A1.

Best regards

Richard

 

[Calvin Zwaan]

Thanks

 

[lenze]

If your times are entered manually, this might be helpful.
http://vbaexpress.com/kb/getarticle.php?kb_id=882

lenze