I have a App formula of TOTALHOURS([Time])*50.00 = £16.67 where [Time]=00:20:00
Yet if I create 2 virtual columns:
[VC Time] a decimal to 2 places with a formula of TOTALHOURS([Time]) the result is 0.33
[VC Total] a price to 2 decimal paces with a formula of [VC Time]*50 the result is £16.50
£16.67/50 = 0.3334 vs the 0.33 used in the virtual columns
LinkedIn
Twitter
