Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello, all,
The Time functions in my Excel 2000 no doubt can do what I want, but I can't fugure out a solution. Assume that in Cell A1 I have the number 12.25, which represents 12 minutes and 15 seconds, i.e., it is a decimal representation of 12 minutes and another .25 of a minute. Is there a way to get Cell A2 to show the following (without the quotes)? "12:15" That's "12 colon 15" Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
M/S Visual C++ Run Time Error when attempting to use functions | Excel Worksheet Functions |