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

Date and Time Conversion
 

=A1+B1

"Mikekap" wrote:

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

Date and Time Conversion
 

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.

--
Rick (MVP - Excel)


"Teethless mama" wrote in message
...
=A1+B1

"Mikekap" wrote:

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

Date and Time Conversion
 

Good lord! That was almost too simple. And it works.

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

Mike

"Teethless mama" wrote:

=A1+B1

"Mikekap" wrote:

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