View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] william.mcseveney@ntlworld.com is offline
external usenet poster
 
Posts: 14
Default 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