Here’s one that I have not got a clue on. I have read the VB help on format and custom format but this does not help.

I want to save to a database a value as a double but display it as minutes/seconds/hundreds of a second just like a stopwatch time

01:45:23

Which would be 1 minute 45 seconds and 23 hundreds of a second.

Which would be stored in the database as a double value of 105.23 if you see what I mean, but displayed in my label as 01:45:23

I have quickly put together a test app with just a label and a command button which of course given I have do it does not work as you cannot add 0.01 to a label formatted as I have done.

Any pointers on how I can go about this one

Code:
Private Sub Command1_Click()
Label1.Caption = Label1.Caption + 0.01
Label1.Caption = Format(Label1.Caption, "#######00:00:00")
End Sub