Multiplying time by money - how?

[Retreatgal]

I am hoping someone might be able to help me out here. I have an example of
some worksheet cells below. I have formatted the cells with time in it as
custom: hh.mm.

I need to multiply the overtime hours (F2) by the over time rate of $50.00
per hour (C4) to get the overtime cost. I then need to sum the G column to
get the total overtime cost (there are multiple entries in my worksheet. I
have tried quite a few things but have been unsuccessful.

Does anyone know how to do this and if so what is the formula? The previous
formula of =F2*C4 does not work.

1 A B C D E F
G
----------------------------------------------------------------------------
------
2 Date | Start | Finish |Job|Total Hrs|Overtime|Overtime Cost
----------------------------------------------------------------------------
------
3 14/08/04|1:00PM |7:00 PM|xyz|6:00 PM | 02:00 | ?

4 Overtime cost per hours | $50.00 |

Thanks

Essie ( please do not reply to my email address)

 

[Frank Kabel]

Hi
try
=F2*24*C4
and format this cell as 'Number'