Converting seconds to m.ss
Posted on 2003-11-22
I am working on a way of converting seconds to m.ss but all i can get is hh.mm.ss using:
VarSeconds = 313.069875
VarTime = Format(DateAdd("s", VarSeconds, "00:00:00"), "hh.mm.ss")
This returns the time 00.05.13, but i would like 5.13 to be returned.
Also if the time is for example 10 minutes it needs to return 10.00 and not 0.00