+ Reply to Thread
Results 1 to 2 of 2

Editing Units on X-axis ( converting hh:mm:ss to hh:mm)

Hybrid View

  1. #1
    Registered User
    Join Date
    12-13-2015
    Location
    london
    MS-Off Ver
    office 365
    Posts
    1

    Editing Units on X-axis ( converting hh:mm:ss to hh:mm)

    Hi , really stuck on this problem

    not sure if i can post a gyazo but you can see my problem here

    https://gyazo.com/3fd40915a6469ba8ca5d6ca4b5dc9c74

    please help , thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,391

    Re: Editing Units on X-axis ( converting hh:mm:ss to hh:mm)

    If those are actual time values (and not text strings that look like time), it seems like it should be as easy as changing the number format on the X-axis to "hh:mm".
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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] Converting units
    By cotonishu in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-09-2013, 12:16 AM
  2. Secondary X-axis with different units
    By Engineer_SA in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-12-2012, 03:13 AM
  3. X axis units
    By Sibrulotte in forum Excel General
    Replies: 2
    Last Post: 10-31-2011, 10:39 AM
  4. converting time units
    By tinsles2 in forum Excel General
    Replies: 1
    Last Post: 03-31-2011, 10:50 PM
  5. Converting units and decimal places.
    By proepert in forum Excel General
    Replies: 3
    Last Post: 11-23-2009, 10:06 AM
  6. Secondary Axis, X-axis spacing (time units)
    By firefly2k8 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-01-2008, 03:48 PM
  7. converting Time to units
    By hellZg8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2006, 10:06 PM
  8. [SOLVED] Converting Units
    By Marie in forum Tips and Tutorials
    Replies: 7
    Last Post: 09-10-2005, 02:09 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1