How can I transform this 206,5 into 206:30h Thanks. Marco
M Michel Walsh Oct 23, 2007 #2 int(x) & Format( x / CDec(24), ":nn" ) Hoping it may help, Vanderghast, Access MVP
M Marco Oct 23, 2007 #3 THANK YOU Michel Walsh said: int(x) & Format( x / CDec(24), ":nn" ) Hoping it may help, Vanderghast, Access MVP Click to expand...
THANK YOU Michel Walsh said: int(x) & Format( x / CDec(24), ":nn" ) Hoping it may help, Vanderghast, Access MVP Click to expand...
M Marshall Barton Oct 23, 2007 #4 Marco said: How can I transform this 206,5 into 206:30h Click to expand... Use a text box expression: =Int(x) & Format(60*(x-int(x)). "\:00")
Marco said: How can I transform this 206,5 into 206:30h Click to expand... Use a text box expression: =Int(x) & Format(60*(x-int(x)). "\:00")
