+ Reply to Thread
Results 1 to 2 of 2

Long date/short date conversion and cycle time calculation

  1. #1
    Registered User
    Join Date
    02-22-2009
    Location
    MORRISTOWN, NJ
    MS-Off Ver
    MICROSOFT 365
    Posts
    60

    Long date/short date conversion and cycle time calculation

    TAB NAME: CONTRACT WORKSPACE QUEUE

    Need help converting long dates (Friday,14 Feb, 2014) to short dates (02/14/2014).

    Once that date is converted into a short date format, need to calculate the total cycle time (Column M) by subtracting my "Create Date" (Column B ) from "CW Create Date" (Column J).

    Thank you!

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,290

    Re: Long date/short date conversion and cycle time calculation

    Take a look at this converting formula column H worksheet 'CONTRACT WORKSPACE REQUEST SUMM'.
    Not 100% sure if it works with english language
    Calculation time is just =J10-B10
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Panel data Conversion-Short to long
    By tulasiram in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2013, 11:36 AM
  2. [SOLVED] Date time stamp to date conversion
    By N8237 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2012, 11:25 AM
  3. Date conversion & calculation
    By jmh in forum Excel General
    Replies: 3
    Last Post: 05-22-2007, 10:42 AM
  4. Date and Time:short function
    By Altec101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2006, 04:10 PM
  5. [SOLVED] Date & time short cut
    By Conditional Formatting in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2005, 01:10 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