apply conditional format to time

  • Thread starter Thread starter TD
  • Start date Start date
T

TD

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?
 
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.

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with Time 4
Conditional Formatting 3
Daily Time Sheets with Rounding 1
Excel Convert Datetime Stamp to HH and MM Worked 7
Excel Conditional Formatting Removal 7
Difference between two date/time values 5
Conditional formatting on a dynamic range - workaround 1
Excel 2007 vs. 2003 differencies for custom format [h]:mm:ss 3

Back
Top