Thanks:  0
Likes:  0

1. 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. 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. Format/Cell/Number/General

4. 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. 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. 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

## User Tag List

#### Posting Permissions

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