ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Figuring cost based on hours (https://www.excelbanter.com/excel-discussion-misc-queries/142692-figuring-cost-based-hours.html)

Breezy77

Figuring cost based on hours
 
i need to get a total cost for time tracked. When I use a basic formula it
is incorrect, and I am not sure what I need to do.
Ex: Hours worked: 208:30
Cost per hour is: $25
Total should be: $5,207.50
When I multiply I get $217.19!!!! I can't get the right answer. What sort
of formula do I have to use?

AKphidelt

Figuring cost based on hours
 
There must be some rounding errors going on. But you should be able to
multiply your answer by 24 and get the right figure.

"Breezy77" wrote:

i need to get a total cost for time tracked. When I use a basic formula it
is incorrect, and I am not sure what I need to do.
Ex: Hours worked: 208:30
Cost per hour is: $25
Total should be: $5,207.50
When I multiply I get $217.19!!!! I can't get the right answer. What sort
of formula do I have to use?



All times are GMT +1. The time now is 11:25 PM.

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