Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Extract Time From Date & Time

  1. #1
    Join Date
    20th June 2006
    Posts
    19

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th February 2004
    Location
    Florida
    Posts
    181

    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

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    20th June 2006
    Posts
    19

    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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    9th June 2007
    Posts
    70

    Re: Extracting Time From Date & Time

    Hi,

    With date/time in A1

    =MOD(A1,1)

    format as time.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    20th June 2006
    Posts
    19

    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

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    9th June 2007
    Posts
    70

    Re: Extracting Time From Date & Time

    You too.

    Eric

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,698

    Re: Extracting Time From Date & Time

    Another way.

    =INT(A1)

    Oops, my bad, that for the date

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Date & Time As Text To Real Date & Time
    By [sHaQ] in forum EXCEL HELP
    Replies: 5
    Last Post: March 3rd, 2012, 00:06
  2. Replies: 9
    Last Post: March 10th, 2008, 23:59
  3. Replies: 3
    Last Post: February 21st, 2008, 19:18
  4. Extract Date & Time From Text
    By milkshake in forum EXCEL HELP
    Replies: 18
    Last Post: August 10th, 2007, 22:58
  5. Replies: 6
    Last Post: September 7th, 2006, 14:01

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
  •  
porno