Changing from hours to minutes.

  • Thread starter Thread starter GEM
  • Start date Start date
G

GEM

I have a report that was sent to me as follows,

A1=1:00:00
A2=2:00:00
A3=5:00:00

How can I change this from hours to minutes, the 1, 2, 5 are minutes, not
hours!!
 
Put 60 in an empty cell
Edit|copy that cell

Select the range to fix
Edit|Paste special|divide and values

clear up that cell with the 60 in it.
 
Thank you very much!!

Dave Peterson said:
Put 60 in an empty cell
Edit|copy that cell

Select the range to fix
Edit|Paste special|divide and values

clear up that cell with the 60 in it.
Click to expand...
 
Back
Top