Hi,
So I have an sheet that has time in seconds which I converted to minutes and Seconds (so it is now text, not numbers). I am trying to have a conditioning formatting filter to have those whose time is greater then 19 minutes in row E be highlighted in red. Row E is a formula which takes the numbers from row D and converts it from seconds to minutes and Seconds as text. I have been trying to figure this out for the past hour and it has me confused! I've read all previous threads but still can't seem to figure it out! I've attached an example for further explanation.
Also, In the actual spreadsheet I am using, I am using a SUMIF Formula is row D to pull the data. Is it possible to combine Row D and E's formulas in one cell so I don't have to hide row D when I figure out how to conditionally format the text.
ROW D Formula: =SUMIF('Data Sheet'!$A:$A,Table511[@[Name]:[Name]],'Data Sheet'!G:G)
Row E Formula: =TEXT(D2/86400,CHOOSE(MATCH(D2,{0,60,3600},1),"s ""sec""","m ""min"" s ""sec""","[h] ""hrs"" m ""min"" s ""sec"""))
Any help would be awesome!!!!!
Bookmarks