Conditional Formatting 2007
Thankyou.
"Pete_UK" wrote:
This has nothing to do with conditional formatting.
Does 5:25 represent 5 hours and 25 minutes, or is it 5 minutes and 25
seconds. If it represents hours, then just enter:
5:25:0
in the cell. If it is 5 minutes, then enter it as:
0:5:25
Then you can use Format | Cells | Number tab | Custom and enter
[hh]:mm or [mm]:ss as appropriate. The square brackets will stop the
numbers from wrapping at 24 hours or 60 minutes.
Hope this helps.
Pete
On Nov 22, 10:16 pm, Steved wrote:
Hello from Steved
Excel 2007
Conditional Formatting
What is needed please for me to type in Cell value 5:25 as a time.
Thankyou.
|