apply conditional format to time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TD - 27 May 2008 22:33 GMT

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?

Reply to this Message

David Biddulph - 27 May 2008 23:37 GMT

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

>I have a spreadsheet (Excel 2003) that imports time data from another
> application in the following formats displayed on the formula bar; for
[quoted text clipped - 3 lines]
> time over one hour to color code. I have been unsuccessful changing the
> format of the imported data. Does anyone have a suggestion?

Reply to this Message

Peo Sjoblom - 27 May 2008 23:44 GMT

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 edit>paste special and select add.

Signature

Regards,

Peo Sjoblom

Reply to this Message