Hi,

I have data in the follwing format in one cell: 0d 0h 13m and I need
to display only minutes and then if amout of minutes greater than 15,
color in red.

I tried:

TEXT('Historic Data'!H11,"h"" hr"" m"" min""")

and

TIME(HOUR('MyTab'!H11), MINUTE('MyTab'!H11), 0)


they will both display hr and min.

If I try:

TEXT('Historic Data'!H11," m"" min""") instead of 13 min, I get 1 min.

I'd really appreciate some help...

Thanks a ton,

Elena