Calculating pay from Time in Excel 1

[lftrypft]

I'm creating a table to calculate overtime pay per week.
I've summed the total hours per week, but I don't know how to take the hours and times the hours and remaining minutes by $20/hour. Such as 41:00:00*$20/hour.

Any ideas?

Thanks,

Mike

 

[woja]

Assume you have the following table:
[tt]
A B C
1 Time Rate Pay
2 12:30:00 $20.00 *
[/tt]
Then the formula you want in [tt]C2[/tt] (where the * is) is:

[tt]=A2*B2[/tt]

(This asssumes that the contents of [tt]A2[/tt] and [tt]B2[/tt] are numeric values formatted, respectively, as time and currency).
Hope this helps.


[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[lftrypft]

Thank you Roger,

I formatted the time cell with a custom format [h]:mm:ss. I did this so when I added the daily hours together, I would get a number over 24 hours.

A B C
1 Hours:Minutes worked
2 9:30 Mon
3 8:00 Tue
4 8:45 Wed
5 26:15 Total

Would you know how I can convert the time format to a number format so I may do the calculation =A2*B2?

 

[woja]

The value in the cell is a number. The formatting tells Excel how to display it, so you can just use it as it is.

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[woja]

A bit more information.
When you ask Excel to format a cell as, say, a date or time, it treats the cell contents as a number of days (and parts of a day - the bit after the decimal point) since January 1st 1900 (this is day 1).
So a numeric value of [tt]0.5[/tt] formatted as [tt][ignore][h][/ignore]:mm:ss[/tt] will display as [tt]12:00:00[/tt].

Hope this helps.

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[woja]

Just realised that I gave you formula to calculate the value at $20 per day...
Should be:
[tt]
=(A2*24)*B2
[/tt]
to do it at $20 per hour
Sorry.

[tt]________________________________________________________________
Roger
Life is a game of cards in which the deck contains only jokers.[/tt]

 

[lftrypft]

Roger,

Yes, I had forgotten "time" was a number. That will make it work. Thank you!!!

Mike