Proper Formula For COnverting Text Time To Decimal

[Ark68]

I don't think I'm on the right course for converting my text timne values to that time's decimal equivalent.

pgm_start = (TimeValue(uf8_post.uf8_d_start.Caption) / 24)
pgm_end = (TimeValue(uf8_post.uf8_d_end.Caption) / 24)

uf8_d_start and uf8_d_end are text boxes in userf orm uf8_post. They hold time values in text format.

uf8_d_start = "6:00 PM"
uf8_d_end = "8:00 PM"

After the formulae,

pgm_start = 0.03125
pgm_end = 3.47222222222222E-2

I don't think I am using the right formula as these answers don't look right.

 

[Ark68]

Oh, I have it partially figured out. It should by * 24 not / 24.

 

[JoeMo]

format(Timevalue("6:00 PM"),"0.00") will return 0.75 (the time as a fraction of a day)