|
|
#3
09-05-2011, 02:19 AM
|
|||
|
|||
Hi
You need, first of all, to understand how Excel stores time/date entries. Excel stores times and dates as an integer from 1 January 1900. So if you formatted a cell for example as days ("dd") and typed the figure 10 in that cell you would have 10/01/1900 in the formula bar. Why do you want to format a cell with a format of minutes? If you explain why you need this we may be able to help you further. Tony(OTPM) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Cell formulas & formatting
|
kungfauxn00b | Word Tables | 3 | 04-05-2011 04:54 AM |
|
Add a period of time to a referenced "Time" cell?
|
derelyth | Excel | 4 | 03-27-2011 04:31 PM |
| How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
|
Conditional formatting of cell, Excel 2003
|
Scaffold | Excel | 2 | 05-01-2010 08:56 AM |
|
Cell formatting
|
Niko | Excel | 5 | 04-23-2009 12:05 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode