April 18, 2020
I am trying to track run times in minutes and seconds for members in my building and have it highlight when they exceed their goal. Every format that I've tried shows the run times in hours. I have used the formula =TIME(0,G8,H8) so i can highlight the times but that takes 4 cells to get what I am trying to accomplish. In the cell E2 I have the time of one individual and have inputted the formula =AND($B2="F",C2="Y",$G2>"15:50") into conditional formatting but it is not working. Is there is anything else that can be added to get the time highlighted? For the cell not to show in just hours instead just show in minutes and secs only?
Thanks in advance