Formula Cell Format -Change H:MM:SS to Currency

[Darrell]

I am trying to create a time sheet to track my hours and pay. When the cell format is H:MM:SS, the data is correct but wrong format. When I change it to currenct the data changes. Any ideas?

 

[Peo Sjoblom]

To get a monetary value using time and payrate,

=time*24*payrate

assume you have time 16:00 in B2 and a payrate of $20

=B2*24*20

format as currency

--

Regards,

Peo Sjoblom

I am trying to create a time sheet to track my hours and pay. When the

cell format is H:MM:SS, the data is correct but wrong format. When I change
it to currenct the data changes. Any ideas?

 

[Darrell]

Thanks, that helped. It was killing me!