+ Reply to Thread
Results 1 to 2 of 2

Possible to use only minutes and seconds in cell time format?

  1. #1
    Garehead
    Guest

    Possible to use only minutes and seconds in cell time format?

    I'm trying to figure out a way to format cells so that I only have to input
    minutes and seconds only, rather than having to type in the hour as well.

    Is there a way that Excel will do this automaticaly, or is there a way to
    format without the hour being included?
    --
    Thanks,
    Garehead

  2. #2
    JE McGimpsey
    Guest

    Re: Possible to use only minutes and seconds in cell time format?

    If you enter a decimal point after the seconds, XL will interpret the
    input correctly.

    Alternatively, you might look at

    http://cpearson.com/excel/DateTimeEntry.htm



    In article <AE698335-6AC4-4DF6-A9CC-E5B96BF6D8B0@microsoft.com>,
    "Garehead" <Garehead@discussions.microsoft.com> wrote:

    > I'm trying to figure out a way to format cells so that I only have to input
    > minutes and seconds only, rather than having to type in the hour as well.
    >
    > Is there a way that Excel will do this automaticaly, or is there a way to
    > format without the hour being included?


+ 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