Results 1 to 6 of 6

Formula / Timestamp

Threaded View

  1. #1
    Registered User
    Join Date
    02-26-2015
    Location
    Bradford, England
    MS-Off Ver
    Microsoft Office 2010
    Posts
    57

    Formula / Timestamp

    Good Evening,

    I'm trying to find a formula that will extract the Date in a DD/MM/YYYY format from a timestamp from an automated excel report that has the format DD/MM/YYYY HH:MM.

    Timestamp in cell D6 results to appear in I6.

    Any Help is greatly appreciated.

    Tom
    Last edited by moni_tm; 06-01-2015 at 01:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Timestamp when value changes by formula
    By rgs694 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 01:16 PM
  2. [SOLVED] Timestamp formula help
    By Chgardne in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-10-2014, 01:32 AM
  3. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  4. Timestamp Formula
    By mcmuney in forum Excel General
    Replies: 2
    Last Post: 10-06-2010, 07:26 PM
  5. Timestamp/Date Formula
    By mcmuney in forum Excel General
    Replies: 3
    Last Post: 09-14-2010, 06:35 PM

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