Announcement

Collapse
No announcement yet.

Extract Time From Date & Time

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Extract Time From Date & Time

    Hi there

    have a date & time eg. 27/06/2008 17:39:00

    and all I want to do is extract the time

    but everything I try returns the excel 39626.7354

    any pointers?

  • #2
    Re: Extracting Time From Date & Time

    Hello,

    Can you use?:
    =RIGHT(A1,8) format as general works for me. Assumes your data is in A1.

    HTH

    JL

    Comment


    • #3
      Re: Extracting Time From Date & Time

      nope tried that,

      right, mid & left all take the reference from serial date even though it looks like the dd.mm.yyyy hh.mm.ss in the cell and the address bar

      can turn it the other way round from number to date with =datevalue(A1) where a1 is the serial date

      Comment


      • #4
        Re: Extracting Time From Date & Time

        Hi,

        With date/time in A1

        =MOD(A1,1)

        format as time.

        Comment


        • #5
          Re: Extracting Time From Date & Time

          cheers Eric.. works nicely

          I had used text to columns as a last resort

          ta

          have a good weekend

          Alex

          Comment


          • #6
            Re: Extracting Time From Date & Time

            You too.

            Eric

            Comment


            • #7
              Re: Extracting Time From Date & Time

              Another way.

              =INT(A1)

              Oops, my bad, that for the date

              Comment

              Working...
              X