CODEWITHSUNDEEP
exceldatetimetimevba
Devendar
Devendar

Reputation: 483

Day current time for function using excel vba

searched on Google I found one. Is it possible to format time in [h]:mm format using VBA?

Dim currentTime As Date
currentTime = TimeOfDay

I passed currentTime into database when I dumped data - showing put put as 00.00.00.000000 not understood why its showing different? Is there any other function to call current time 00.00 AM/PM

Upvotes: 5

Views: 26209

Answers (1)

brettdj
brettdj

Reputation: 55672

To format the current time to your specs try

MsgBox Format(Now(), "hh:mm AMPM")

Upvotes: 9

Related Questions