Results 1 to 17 of 17

Need help with dates conversion

Threaded View

  1. 09-02-2016, 09:04 AM #1
    Ash_Maverick
    Ash_Maverick is offline
    Forum Contributor
    Join Date
    08-23-2016
    Location
    India
    MS-Off Ver
    MS Office Professional Plus 2013
    Posts
    194

    Need help with dates conversion

    Hi Guys,

    Please help me out with the attached file. The dates are in UK format and i just need the correct value to come out of them when I run a pivot. Somehow 10/8/2016 18:03 show me 8-Oct when I convert it.
    Attached Files Attached Files
    Ash
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conversion of dates from Hijri Calendar (1317-1473) to Gregorian calendar (1900-2050)
    By IMA_Saihat in forum Tips and Tutorials
    Replies: 5
    Last Post: 01-02-2020, 07:45 AM
  2. Conversion of European Dates to US dates
    By ttyler916 in forum Excel General
    Replies: 5
    Last Post: 02-18-2013, 04:58 AM
  3. Conversion of dates/times
    By DesCall in forum Excel General
    Replies: 4
    Last Post: 05-27-2012, 12:26 PM
  4. Conversion of dates times
    By DesCall in forum Excel General
    Replies: 1
    Last Post: 05-27-2012, 10:31 AM
  5. Conversion of dates from Text format
    By jayantabhattacharji in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-18-2011, 04:25 AM
  6. Excel 2007 : Is it possible to undo automatic conversion of numbers into dates?
    By spsafe in forum Excel General
    Replies: 1
    Last Post: 07-30-2009, 04:26 PM
  7. Problem with dates after conversion
    By John Kleinbohl in forum Excel General
    Replies: 2
    Last Post: 03-09-2006, 01:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1