philottawa1961
New Member
- Joined
- Apr 21, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I need to get the decimal value of seconds of the system time. Typing "time" in CMD window shows time in format "hh:mm:ss.dd". I need the dd (decimal value of seconds). I want to capture the ss.dd at the start of the macro, the ss.dd at the end of the macro, and subtract the first from the second to show the execution time. My result might show "Macro executed in 0.03 seconds". Presently I can only find seconds in whole integer numbers, so execution time shows as 0 seconds, which is most unhelpful.