Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell formatting or formulas
How do I make 1.50 appear as 1.30 in a given cell? I have a cell with times
such as 1.00 minute, 1.50 minutes, 2.50 minutes, 3.00 minutes, etc. I want all the x .50 digits to appear as x.30 digits (30 seconds to a half minute) |
#2
|
|||
|
|||
Divide by 1440 and format as mm:ss
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "George" wrote in message ... How do I make 1.50 appear as 1.30 in a given cell? I have a cell with times such as 1.00 minute, 1.50 minutes, 2.50 minutes, 3.00 minutes, etc. I want all the x .50 digits to appear as x.30 digits (30 seconds to a half minute) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
Cell Formats in formulas | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |