Creating a date time cell

[RYork]

How do you combine a date cell with a time cell to create a single date and time cell?

example:
A B C
1 03/04/02 | 08:15 | 03/04/02 08:15 |

 

[Ian Mac]

On 2002-03-04 12:55, RYork wrote:
How do you combine a date cell with a time cell to create a single date and time cell?

example:
A B C
1 03/04/02 | 08:15 | 03/04/02 08:15 |

Simply adding the 2 together should do the trick!

 

[RYork]

I tried that and get weird results.

 

[Mudface]

Try formatting your result cell as

mm/dd/yy hh:mm

Also, make sure cell C1 =A1 + B1 rather than A1 & B1.

 

[RYork]

That's how I'm entering it. Here is the exact cell contents:
2/19/02 7:25

the results are 4/24/04 7:25

 

[RYork]

One thing I didn't tell you was that the data was imported from an AS/400. When I enter the dates manually, adding the two fields works.