Date and Time Conversion

  • Thread starter Thread starter Mikekap
  • Start date Start date
M

Mikekap

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
 
Just as a follow up to Teethless mama's posting, Excel stores date-times as
floating point number... the integer portion represents the number of days
since January 1, 1900 and the decimal portion represents the fractional part
of the day (for example, 6:00am is 0.25). So, if you add your two cells
together, you are creating the floating point number that Excel sees for
that date-time... the format you display your date and time in is strictly
for your convenience.
 
Good lord! That was almost too simple. And it works.

Thanks. And thanks also to Rick for the explanation of why it works.

Mike
 
Back
Top