CODEWITHSUNDEEP
exceltimeexcel-formula
Hooli
Hooli

Reputation: 1195

calculate cost from hours worked

I have two columns in my spreadsheet.

A                      B
Total Hours Worked     Total Cost

A is formatted as a duration/time, i.e. 01:34:20 and is the total elapsed time it's taken to complete a task

B should be a formula of some sort that calculates the cost. Right now I have the function A2*25 but this results in B2 being too little.

What do I need to do to correct the formula so the total cost is correct?

Upvotes: 2

Views: 3164

Answers (2)

Robin Gertenbach
Robin Gertenbach

Reputation: 10776

Excel stores durations as fractions of days.
You just need to multiply the duration by 24 to have the number of hours worked and you get the correct result.

=A2*25*24

Upvotes: 2

Techidiot
Techidiot

Reputation: 1947

You can use this as B2 - 

=(HOUR(A2) + MINUTE(A2) / 60 + SECOND(A2) / 3600)*25

Upvotes: 2

Related Questions