Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Entering Time (2003)

    I want to enter a time in and time out in adjacent cells and get the difference. Excel wants the time expressed in numbers up to 24:00 where 1:00 is 1a.m. and 24:00 is 12 midnight. I want to be able to enter a time from 0:00 to 12:00 and tell the spread whether I want it to signify a.m. or p.m. Can someone help?

    Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Entering Time (2003)

    Do you mean you want a separate column to enter the AM or PM in? Or do you just want to type '1:00 P'?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering Time (2003)

    I want to be able to type in a time from 1 to 12 and somehow tell Excel that it is either a.m. or p.m. I'll also need to determine the amount of time spent by subtracting time in from time out.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Entering Time (2003)

    You can just enter '1:00 p' or '1:00 a' and that should work.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering Time (2003)

    I need to be able to calculate differences in time in and time out. If I enter 1:00p doesn't that make the cell alphanumeric?

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Entering Time (2003)

    You need to leave a space between the last zero and the P, then Excel will interpret it as PM and enter the time accordingly.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Atlanta, GA
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering Time (2003)

    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •