Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Time (not time)

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how do you format a cell so that excel formats it as an amount of time, instead of an actual time? for example, i want to record a number "19:42" as 19 minutes and 42 seconds...not as 7:42pm. any suggestions?

    thanks!
    -mercyat3pm-

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Enter it as 0:19:42 and format as...

    [m]:ss

    [ This Message was edited by: Mark W. on 2002-04-26 13:21 ]

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Format/Cell/Number/General

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    neither of these solutions is working for me. the problem is this: what if i want to put in something like 58 minutes and 43 seconds? excel still handles it as a clock time (12:58:43am in this example). i'm just trying to track the amount of time that a certain simulation takes to run. i don't want "AM" or "PM" or anything related to a time of day. any other suggestions?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-26 13:26, mercyat3pm wrote:
    neither of these solutions is working for me. the problem is this: what if i want to put in something like 58 minutes and 43 seconds? excel still handles it as a clock time (12:58:43am in this example). i'm just trying to track the amount of time that a certain simulation takes to run. i don't want "AM" or "PM" or anything related to a time of day. any other suggestions?
    Like I said... enter as 0:58:43 and format as [m]:ss

    BTW, don't let what's displayed in the formula bar lead you astray.



    [ This Message was edited by: Mark W. on 2002-04-26 13:47 ]

  6. #6
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    This may not be the cleanest solution:


    =MINUTE(F21)&" Minutes : " & SECOND(F21)&" Seconds"

    Where "F21" is a cell that was formatted with Custom [m]:ss and the start time entered as 0:43:22 or whatever. The cell that containes this formula: =MINUTE(F21)&" Minutes : " & SECOND(F21)&" Seconds"
    will give "43 Minutes : 22 Seconds" as the displayed result. Hope this helps. JSW

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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