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

D

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?
 
P

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

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