Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Military time (excel 2002/xp)

    I created an SS that would allow me to enter 750 and have it show up as 7:50: 1630 would be 16:30. The status bar at the top of excel reads 7:50:00 AM or 4:30:00 PM, respectively. Formatting is in the [h]:mm style.

    When I copy the SS to a new sheet, eg Dec to Jan, I can no longer enter the 750 or 1630 and get the desired results. If I enter 750, the cell reads 18000:00 while the top status bar reads 19-01-1902 12:00:00 AM. The formatting is still in the [h]:mm style.

    Why when I copy the SS to a new sheet, can I no longer get the the 750 to enter as 7:50 in the cell and 7:50:00 AM? I know I am missing something simple, but for the life of me and can't figure out what.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Military time (excel 2002/xp)

    You haven't told us what you did in the original sheet that interprets 750 as 7:50. And did you copy the worksheet as a whole (through Edit | Move or Copy Sheet or something similar), or did you copy a range of cells to another sheet?

  3. #3
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Military time (excel 2002/xp)

    As i mentioned, it is something simple. When I copied the sheet over, I did not copy the VBA code that allowed me to enter 750 as 7:55. And this is only the start of the week!!!

Posting Permissions

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