Getting Decimal Equivalent of Textbox Time Entry

Ark68 · Mar 21, 2018

I'm a bit stumped ... when I enter "0:00" into textbox 'cu2_end' ....

Code:

etc_cu2 = CDate(cu2_end.Value)
Debug.Print etc_cu2

I am returned the correct value for 'etc_cu2' which is 12:00:00 AM.
How can I get the decimal equivalent returned for 'cu2_end'?

louisH · Mar 21, 2018

Hi,

This ??

Code:

etc_cu2 = Format(CDate(cu2_end.Value), "0.00")
Debug.Print etc_cu2

Ark68 · Mar 21, 2018

Yep ... that's what I was looking for LouisH.
Thank you so much!