Time (not time)

mercyat3pm · Apr 26th, 2002, 02:00 PM

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-

Mark W. · Apr 26th, 2002, 02:18 PM

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

[m]:ss

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

Brian from Maui · Apr 26th, 2002, 02:18 PM

Format/Cell/Number/General

mercyat3pm · Apr 26th, 2002, 02:26 PM

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?

Mark W. · Apr 26th, 2002, 02:29 PM

Quote:

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 ]

Joe Was · Apr 26th, 2002, 02:49 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 02:00 PM	#1
mercyat3pm New Member Join Date: Apr 2002 Posts: 9	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-

Apr 26th, 2002, 02:18 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Enter it as 0:19:42 and format as... [m]:ss [ This Message was edited by: Mark W. on 2002-04-26 13:21 ]

Apr 26th, 2002, 02:18 PM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Format/Cell/Number/General

Apr 26th, 2002, 02:26 PM	#4
mercyat3pm New Member Join Date: Apr 2002 Posts: 9	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?

Apr 26th, 2002, 02:49 PM	#6
Joe Was MrExcel MVP Join Date: Feb 2002 Location: Central Florida, USA Posts: 7,541	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