Condition based upon shot time format

[hawkins]

I have a text box in which I display a short time in it. I previously created a conditional under the font section that just referenced field of a pre-calculated percentage. I would like to get rid of the pre calculated percentage and just have the conditional do it for me. I have another text box conditional which looks like this: (([SAIFI]/1.43)*100)>100.0001 And (([SAIFI]/1.43)*100)<200.009. Where inbetween 100 and 200 the text box will go yellow. I would like to do the same with CAIDI but instead of the 1.43 it would be [2:03] in short time. Does anyone have any suggestions?

[June7]

You want to use the time in a calculation like used with SAIFI and 1.43? Convert the time to decimal hours or minutes. 2:03 would become 2.05 hours or 123.0 minutes.

[hawkins]

Correct, so it would be something like this: (([CAIDI]/(123))*100)>100.0001 And (([CAIDI]/(123))*100)<200.009 . Is there a way to convert the time to minutes within the conditional formatting or would I need to use VBA code to do so?

[June7]

x = field name with time values (ex: 2:03) - assuming is a text datatype field

Val(x)*60 + Val(Mid(x,InStr(x,":")+1)) / 60

will return 120.05 minutes

Might be able to include that in the conditional format expression. Makes a long statement.