+ Reply to Thread
Results 1 to 4 of 4

date and time formatting

  1. #1
    rantz
    Guest

    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?


  2. #2
    Bob Phillips
    Guest

    Re: date and time formatting

    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" <lokrantz@gmail.com> wrote in message
    news:1133170348.404633.109030@g49g2000cwa.googlegroups.com...
    > 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?
    >




  3. #3
    rantz
    Guest

    Re: date and time formatting

    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.


  4. #4
    Bob Phillips
    Guest

    Re: date and time formatting

    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" <lokrantz@gmail.com> wrote in message
    news:1133173017.679007.239100@g14g2000cwa.googlegroups.com...
    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.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1