+ Reply to Thread
Results 1 to 4 of 4

*EASY* question 2!!

  1. #1
    Laura \( '_' \)
    Guest

    *EASY* question 2!!

    BlankAnd as a second thought.
    In my A column I need to set it out like this HH:MM (AM/PM) with *no* date,
    just the time.
    How could i achieve this?
    Sorry for my questions but this is the first spreadsheet I have ever
    attempted
    Thanks in advance
    --
    @---}--
    Laura.....
    Liverpool, England

    "Do you know where you're going to?"



  2. #2
    Guest

    Re: *EASY* question 2!!

    Hi again!

    Select column A. Go to Format/Cells and click on Time (on the Number tab).
    You can then select which type of time format you would like.

    Hope this helps.
    Andy.

    "Laura ( '_' )" <[email protected]> wrote in message
    news:[email protected]...
    > BlankAnd as a second thought.
    > In my A column I need to set it out like this HH:MM (AM/PM) with *no*
    > date,
    > just the time.
    > How could i achieve this?
    > Sorry for my questions but this is the first spreadsheet I have ever
    > attempted
    > Thanks in advance
    > --
    > @---}--
    > Laura.....
    > Liverpool, England
    >
    > "Do you know where you're going to?"
    >
    >




  3. #3
    Laura \( '_' \)
    Guest

    Re: *EASY* question 2!!

    Yep...Im so dumb on excel :S
    Thankyou!"!

    --
    @---}--
    Laura.....
    Liverpool, England

    "Do you know where you're going to?"
    <Andy> wrote in message news:[email protected]...
    > Hi again!
    >
    > Select column A. Go to Format/Cells and click on Time (on the Number tab).
    > You can then select which type of time format you would like.
    >
    > Hope this helps.
    > Andy.
    >
    > "Laura ( '_' )" <[email protected]> wrote in message
    > news:[email protected]...
    > > BlankAnd as a second thought.
    > > In my A column I need to set it out like this HH:MM (AM/PM) with *no*
    > > date,
    > > just the time.
    > > How could i achieve this?
    > > Sorry for my questions but this is the first spreadsheet I have ever
    > > attempted
    > > Thanks in advance
    > > --
    > > @---}--
    > > Laura.....
    > > Liverpool, England
    > >
    > > "Do you know where you're going to?"
    > >
    > >

    >
    >




  4. #4
    Don Guillett
    Guest

    Re: *EASY* question 2!!

    Laura,
    For archival purposes, please try to use more meaningful subject lines.

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Laura ( '_' )" <[email protected]> wrote in message
    news:[email protected]...
    > BlankAnd as a second thought.
    > In my A column I need to set it out like this HH:MM (AM/PM) with *no*
    > date,
    > just the time.
    > How could i achieve this?
    > Sorry for my questions but this is the first spreadsheet I have ever
    > attempted
    > Thanks in advance
    > --
    > @---}--
    > Laura.....
    > Liverpool, England
    >
    > "Do you know where you're going to?"
    >
    >




+ 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