Recent content by BobtheHelper

Oops sorry For =right(C4,D4) it's not correct. you need to round with =ROUNDUP(C4,2) so you have 2 decimals And then you do =right(C4,2) so it returns you the decimals. Then you can even be fancy and concatenate =CONCATENATE(F4,$G$3,H4) in F4 i have 3 in G3 I have H in H4 i have 54 //...

Hi, I don't know if you have solved your issue by now, but I guess not since PhilFrisbie's comments don't really help. I just had the same issue with a time which was 3.89 in field C4 So I used: =FIND(".",C4) that returns me the position of the . which is 2 =Left(C4,D4-1) which returns me 3...