combine date and time cells

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a data recorder that records start and start time.
When I export the data out of the device it comes across
with date in one cell [=DATE(104,1,27)] January 27, 2004,
and time in another [(=TIME(3,16,12)] 03:16:12 AM in Lotus
123 format. I open in excel and have tried to combine the
two cells using the "&" key but can't get the result to
yield a date and time in Excel. The formula that I used
to combine the two cells is "=U7&" " & V7" where U7 and
V7 are date and time respectively. I have also tried the
formula as "=U7& V7". The result that I get in Excel is
380130.13625. Even when I format the cell for date and
time I still get the same result.


Any help would be appreciated.
 
Hi Greg!

Use:
=U7+V7

Excel uses dateserial numbers where days is number of days since
31-12-1899 and time is the decimal portion of the number. So add the
two and you get a date and time. You'll need to format to show both
date and time.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top