help with hours minutes and seconds

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

help with hours minutes and seconds

This may be a fairly simple one. I am trying to format a cell so that I
only have to type "124545" to get the result of 12:45:45
(hour:minute:second).

I have tried using "Custom" formatting with the given options in excel,
but have not found the right solution yet. So here I am. Any way to
format the cell so that the output will display as desired (12:45:45)???

Thanks,
CW

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to convert 157.25 minutes, into hours, minutes and seconds.	Al	Excel Discussion (Misc queries)	2	March 11th 09 09:04 AM
Converting hours, minutes, seconds, to hours	chouck	Excel Worksheet Functions	7	January 29th 08 08:00 PM
Formula to Change Hours:Minutes:Seconds to Seconds only	Cheri	Excel Discussion (Misc queries)	4	August 30th 06 12:44 AM
Converting hours:minutes:seconds to just minutes	Dan Vagle	Excel Worksheet Functions	3	July 17th 06 11:20 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds	Ianukotnorth	New Users to Excel	7	May 8th 05 08:11 PM

All times are GMT +1. The time now is 01:12 PM.

Menu

About Us