Convert Text Time to Excel Time
Hi
I have imported a file to excel that contains data that looks like
time e.g 10:30 however the format of the data is General. How can I
get this data to show as an actual time in excel as I need to perform
further calculations on the time once I get it converted. I just need
it to show as hh:mm
Many thanks
W
|