View Single Post
  #1   Report Post  
Mahnaz
 
Posts: n/a
Default calculating with a time format cell

Hi,
I wana calculate the monthly wages,then in one cell I have hourly wage and
in other cell I have total work hour for example (120:45:40),and I want
multiple this two cells.
How can I convert or change the time cell to a number and write a formula
for multipling them?
Thank you so much.
--------
Regards
Mahnaz