Number to time formula. 1

[bobpv]

Hi all,
I am racking the noggin trying to come up with the right formula, and seem to only draw blanks. Any advice please! I have data coming in as a number field, this is holding the process time in 10ths. So 1.5 is 90 min. I want to convert to Hours and min, or have it display as 1hr 30 min. I would also want .75 to display as 45 min.

I am stuck! Thanks for a hint!

 

[lbass]

This should work:

totext(truncate({yourtime.field}),0)+"hrs"+" "+ totext(val(mid(totext({@yourtime.field}),instr(totext({yourtime.field}),".&quot))*60,0,"&quot +"mins"

Please note that you said your data was in 10ths (e.g.,.5) an then provided an example that used hundredths (.75). This formula will work regardless.

-LB

 

[bobpv]

SWEET!

I was missing the instr function. Thanks a million for the assist!