Date and Time Conversion

[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

 

[Teethless mama]

=A1+B1

 

[Rick Rothstein]

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.

 

[Mikekap]

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

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

Mike