I'm trying to write a macro that takes a time value in seconds (decimal) and converts it to mm:ss.00 format (two decimal places.) The closest I've come is this:
Application.Text((1.23 / 86400), "mm:ss.00")
Which results in:
00:01.2
I can't figure out why it's not showing the second decimal place. Format() doesn't work either, it does something even weirder.
00:01.23
. Could it be locale specific?Debug.Print Application.Text((1.23 / 86400), "mm:ss.00")
and the result was00:01.23