Minute Formatting

S

Sharon

I have a workbook where I am entering two values as
minutes for example I have 5:24 minutes & 7:00 minutes -
Excel is formatting this to be 5:24 am and 7:00 am - how
can I get Excel to format this just as the minutes so that
I can compare the two accurately? I have tried mm:ss but
it is still listing this as a time format with the am. I
need to be able to conditionally format the cell with 5:24
and would need to be able to color the numbers if the
minutes are less or more than the cell with 7:00. Thanks!
 
F

Frank Kabel

Hi
why not use in the conditional format a condition such as
=A1<7/(24*60)

or
=A1<TIME(0,7,0)
 
D

Dave Peterson

I bet you're looking at the formula bar to see the AM. If you look at just the
cell, you'll see that in the format you chose.

I don't think you can change what appears in the formula bar.

And look at Format|conditional formatting
cell value is
Less than
=$a$1

And give it a nice format.
 
Top