Results 1 to 5 of 5

Thread: Extract Time from a Date&time cell

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 10-30-2015, 02:23 PM #1
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    15
    The values you have shows are in date format or text format?
    Reply With Quote Reply With Quote
  2. 10-30-2015, 03:19 PM #2
    Kevin@Radstock
    Kevin@Radstock is offline
    Junior Member
    Join Date
    Dec 2012
    Posts
    16
    Rep Power
    0
    Hi

    A formula approach and format cells as "hh:mm AM/PM"

    =--MID(E2,FIND(":",E2)-2,8)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Outlook Mass Mailer - With time stamp & retained hyperlinks. Multiple email reminders
    By santhosh in forum Outlook Help
    Replies: 0
    Last Post: 10-23-2013, 04:58 AM
  2. Calculate Time Difference Between Time In HH:MM
    By Stalker in forum Excel Help
    Replies: 8
    Last Post: 03-28-2013, 03:27 PM
  3. Date & Time Formats in Different Languages
    By Haseeb A in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 06-10-2012, 02:57 PM
  4. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM

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
  •  

Forum Rules