VBA set a cell value in a time format

[JezzaH]

Hey everyone,

Apologies if this is a really simple solution, but I cannot seem to find exactly what I am after online.

I wish to set the value of cell A1 to a value of 30 seconds. This is so I can have a countdown clock in my spreadsheet.

From my understanding the value is set in the hh:mm:ss format. It's not just a case of Range("A1").Value = 30

Thanks in advance for the help!

Cheers,

Jezza

 

[footoo]

[A1].NumberFormat = "hh:mm:ss"
[A1] = TimeValue("00:00:30")

 

[JezzaH]

Thankyou very much footoo!

 

[Peter_SSs]

Thankyou very much footoo!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.