S
Scott
i'm trying desperatly to display numbers like 2.46, 4.1 to look like 2:46
and 4:10
basically i want to replace the period with a colon and force the decimal to
2 digits.
1. i can get the whole number by saying int([mytime])
2. i can almost get the decimal by saying
Right([mytime],InStr([mytime],"."))
#2 above works except when a number only contains 1 decimal place.
Can someone help me come up with a function that converts 4.1 to 4.10? I'm
only interested in the way it displays. I'm just trying to mimic proper time
format in minutes and seconds.
and 4:10
basically i want to replace the period with a colon and force the decimal to
2 digits.
1. i can get the whole number by saying int([mytime])
2. i can almost get the decimal by saying
Right([mytime],InStr([mytime],"."))
#2 above works except when a number only contains 1 decimal place.
Can someone help me come up with a function that converts 4.1 to 4.10? I'm
only interested in the way it displays. I'm just trying to mimic proper time
format in minutes and seconds.