View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mikekap Mikekap is offline
external usenet poster
 
Posts: 2
Default Date and Time Conversion

I have a spreadsheet with the date in the first column in MM/DD/YYYY format
and the time in the second column in HH:MM format. Is there some way to
convert that to a single date/time column in MM/DD/YYYY HH:MM format so I can
use that column of date/times as the x-axis in a line graph (utility data)?
How? (I'm using Excel 2000.)

Thanks,

Mike