Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with hours minutes and seconds
http://www.cpearson.com/excel/DateTimeEntry.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Rog" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with hours minutes and seconds
CW,
Actually custom formatting does work, as I have used this in the past. Just format custom as ##":"##":"## then when you enter 124545 you will get 12:45:45 Mike -----Original Message----- 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Converting hours, minutes, seconds, to hours | Excel Worksheet Functions | |||
Formula to Change Hours:Minutes:Seconds to Seconds only | Excel Discussion (Misc queries) | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel |