+ Reply to Thread
Results 1 to 2 of 2

0-60 minute time format

  1. #1
    Drew Remsen
    Guest

    0-60 minute time format

    I have a data string of numbers between 0-59 that are part of a time
    signal collected by an instrument that correspond to the minute of the
    time signal. For values between 0-9 I would like them instead to read
    like 00-09. The rest of the digits are already in a two digit format so
    they are fine.How can I accomplish this?
    Andrew

  2. #2
    Karthik
    Guest

    Re: 0-60 minute time format

    -------------------------------------------------------------------------
    Format the cells by
    Format > Cells... > Custom>

    In the "Type:" field enter the following format and this should do
    the trick

    "00:"00

    and click OK

    Thanks
    KB
    -------------------------------------------------------------------------


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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