date and time formatting

A2=2004-09-01 (formatted as date)
B2=00:08:25 (formatted as time)

I want C2 to look like '2004-09-01, 00:08:25'. It's formatted like
'YYYY-MM-DD, tt:mm:ss'

To get the info I use '=EXTEXT(A2;1;10)&", "&EXTEXT(B2;1;8)' but I get
'38231, 00:08:18'

How do I get it to work?

Don't have Swedish Excel, but I would just use TEXT. Try this

=TEXT(A2+B2;"yyyy-mm-dd hh:mm:ss")

but if that doesn't work, then try

=TEXT(A2;"yyyy-mm-dd")&TEXT(B2,"hh:mm:ss")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rantz" <[email protected]> wrote in message
news:[email protected]...
> A2=2004-09-01 (formatted as date)
> B2=00:08:25 (formatted as time)
>
> I want C2 to look like '2004-09-01, 00:08:25'. It's formatted like
> 'YYYY-MM-DD, tt:mm:ss'
>
> To get the info I use '=EXTEXT(A2;1;10)&", "&EXTEXT(B2;1;8)' but I get
> '38231, 00:08:18'
>
> How do I get it to work?
>

I think this is really strange. I don't get the correct info? This is
what I get. How on earth do I get 2004-08-01 from 2004-09-01?

A2=3D2004-09-01
B2=3D00:08:18

(yyyy=3D=E5=E5=E5=E5, hh=3Dtt)
2004-08-01, 00:08:18 '=3DTEXT(A2+B2;"=E5=E5=E5=E5-mm-dd, tt:mm:ss")'
2004-00-01, 00:08:18 '=3DTEXT(A2;"=E5=E5=E5=E5-mm-dd")&", "& TEXT(B2;
"tt:mm:ss")'
00:08:18 '=3DTEXT(B2; "tt:mm:ss")'
2004-00-01 '=3DTEXT(A2;"=E5=E5=E5=E5-mm-dd")'

Another thing, is it possible to lock the rows so that they stay intact
regardless of sorting. I keep messing them up.

That is strange, and one for which I have no answer I am afraid.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rantz" <[email protected]> wrote in message
news:[email protected]...
I think this is really strange. I don't get the correct info? This is
what I get. How on earth do I get 2004-08-01 from 2004-09-01?

A2=2004-09-01
B2=00:08:18

(yyyy=مممم, hh=tt)
2004-08-01, 00:08:18 '=TEXT(A2+B2;"مممم-mm-dd, tt:mm:ss")'
2004-00-01, 00:08:18 '=TEXT(A2;"مممم-mm-dd")&", "& TEXT(B2;
"tt:mm:ss")'
00:08:18 '=TEXT(B2; "tt:mm:ss")'
2004-00-01 '=TEXT(A2;"مممم-mm-dd")'

Another thing, is it possible to lock the rows so that they stay intact
regardless of sorting. I keep messing them up.