ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiply time and wage (https://www.excelbanter.com/excel-discussion-misc-queries/45193-re-multiply-time-wage.html)

TomHinkle

multiply time and wage
 
Should be pretty simple.
you just have to convert the minutes to decimals.
30 minutes = .5 hours right..
so your formula is
hours + (minutes / 60)


"KC" wrote:

I am trying to add hours together and then multiply that by an hourly wage.
For example (in hours:minutes)

38:46 + 24:22 = 63:08 = 63.14 x $8.00 = $505.12

Is there any way to do this in excel or am I asking too much of the program?

Thank you for your help!



All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com