Help on combining date and times together...

  • Thread starter Thread starter bimmerman
  • Start date Start date
B

bimmerman

I have two cells, A1 with a date (11/31/03), A2 with a time (11:00 PM).

How do I put them together into one cell?

My main goal here is to increment the time by 3 hours, but I need t
make sure the actual date gets incremented also if the 3 hours makes i
change days.

When I try doing a concat on the date/time I get a weird number that
can't add my 3 hours to.

Any help would be greatly appreciated, Thanks
 
Ok well, I figured out how to do it, but I'm sure not the best way, s
if anyone knows the proper excel way for future reference that would b
great.

What I ended up doing was copying/pasting the two columns into textpa
and formatted them a tiny bit and pasted them back into excel as on
column. Then I added 0.125 which I found out was 3 hours by trial an
error.

Just goes to show, where there's a will there's a way
 
bimmerman,

Just add them rather than concatenate them, that is
=A1+A2

To add 3 hours,

=A1+A2+3/24

because time is stored as a fraction of 1 day

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top