apply conditional format to time
 

I have a spreadsheet (Excel 2003) that imports time data from another
application in the following formats displayed on the formula bar; for under
one hour, it displays mm:ss When the time is over one hour, it displays
h:mm:ss AM (or PM). When I apply conditional formatting, I can not get any
time over one hour to color code. I have been unsuccessful changing the
format of the imported data. Does anyone have a suggestion?

apply conditional format to time
 

If a format change isn't having any effect, my guess is that your cell
contains text, not a number. Perhaps you've got spurious spaces or
non-printing characters?
--
David Biddulph

"TD" <TD @discussions.microsoft.com wrote in message
...
I have a spreadsheet (Excel 2003) that imports time data from another
application in the following formats displayed on the formula bar; for
under
one hour, it displays mm:ss When the time is over one hour, it displays
h:mm:ss AM (or PM). When I apply conditional formatting, I can not get any
time over one hour to color code. I have been unsuccessful changing the
format of the imported data. Does anyone have a suggestion?

apply conditional format to time
 

It should work, I suspect your data is text, that's not unheard of when it
comes
to imports. Try if this work, custom format an empty cell [mm]:ss or
[hh]:mm:ss depending on what format you would like to have, then copy it,
select the imports and do editpaste special and select add.

--


Regards,


Peo Sjoblom


"TD" <TD @discussions.microsoft.com wrote in message
...
I have a spreadsheet (Excel 2003) that imports time data from another
application in the following formats displayed on the formula bar; for
under
one hour, it displays mm:ss When the time is over one hour, it displays
h:mm:ss AM (or PM). When I apply conditional formatting, I can not get any
time over one hour to color code. I have been unsuccessful changing the
format of the imported data. Does anyone have a suggestion?