George

Posts: n/a

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)

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
Conditional Formatting using result of Cell Formulas	Dave Peterson	Excel Discussion (Misc queries)	0	January 26th 05 02:17 AM
Cell Formats in formulas	C. Lewis	Excel Discussion (Misc queries)	1	January 5th 05 06:37 PM
Formatting a cell as "text" in the number catagory.	Ed	Excel Worksheet Functions	3	December 7th 04 07:12 PM
conditional formatting blank cell	TREK5200	Excel Discussion (Misc queries)	1	December 6th 04 02:23 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 10:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us