VBA: Change Format for Time and Percent

Hi All,

i have this code (created for me by Tinbendr,one of the Forum Expert)

Please Login or Register  to view this content.

In .asa, .cpaht, .resaht, i need them to be in 0:00:00 time format
in .sa, i need it to be in 00.00% format

sample:

6.8798815822 = 0:00:59
2.906903502 = 0:00:25
3.5648148148 = 0:05:08

0.9975 = 99.75%

left side numbers are what's showing in the userform textboxes, the right numbers is the format it should show in the textboxes..
should i add some formulas?

I thought you might be back asking for that

Use the format function

Please Login or Register  to view this content.