I have a cell that has a value format like 0:00:30, (30 seconds). When I view the cell it shows 12:00:30 AM. It's a count down timer that is being used to fill in my textbox in a userform. However, when I pass the value to my textbox it shows up as a value "3.47222222222222E-04".
It maybe because of the way I am passing it. Here is the code
TimeLeft = Sheets("Event Management").Range("C8")
Or if that isn't the fix, then I was thinking I would some how separate the cell that has the formula as 0:00:30 and show 0 hours:0 minutes: and 30 seconds. Something like that..
Any help is much appreciated.