Quirky Formatted Text / Duration Formula
Hello All,
I hope everyone had a great weekend. Wanted to bring something up to the group and wondering if anyone else has seen something similar:
I am currently taking a numeric field (Block Ho...
Forum Discussion
Hi Mark,
Yes, we would prefer to keep the values rounded to the tenth. I believe it is a longer value and only displaying as one decimal point. However, I'm not sure why the numeric value would be anything other than down to the tenth - when I import the data it is rounded to the tenth.
------------------------------
Aidon Olligschlager |
Flight Operations Technical Support
Pentastar Aviation
Waterford MI
aolligschlager@pentastaraviation.com | 248-202-9587
------------------------------
Are you doing anything with the formula beyond just doing ToFormattedText with HHMM as the parameter? It might be a quirk with how QB does the conversion. Have you tried to parse it out yourself and just split it yourself to do the remainder * 6?
------------------------------
Chayce Duncan
------------------------------