I have two columns of data (time in a format that shows hours and sometimes minutes... ie "20h 32m" or maybe "24.5h"). The first column is the estimate of time required and the second is the remaining time.
OE Remaining
24h 17h 20m
16h 16h
40h 28.5h
What I would like to do, is add conditional formatting to the column showing the remaining time... with a data bar (remaining time as a percentage of the original estimate). Because of the nature of my data (table that is reloaded), I want to have the conditional formatting in place (in the cell with the text).
My first challenge is this strange time format. To conquer that, I thought maybe I could apply a conversion like this:
=IFERROR((VALUE(LEFT(J11,FIND("h",J11)-1)))+VALUE(MID(J11,FIND("h",J11)+1,FIND("m",J11)-FIND("h",J11)-1))/60,(VALUE(LEFT(J11,FIND("h",J11)-1))))
this formula will take a cell with a value like "17h 20m" and convert it to "17.333". So, that works fine. I could create two new columns that store this information.
My question - is it possible to show a progress bar in my remaining time column using conditional formatting (a percentage of the original estimate)?
Bookmarks