Cells Time formatting

[Ploom]

Hi,
I have a pb with the cells formatting for a time:
In a cell let's say A1, i would put a time, for ex: 08:00 and I would like to retrieve this value for the use of an Application.OnTime function
However excel considers my 08:00 as 0.3333. I tried to format my cell A1 in time category but it doesn't change anything and when i try a timevalue i have a mismatch error.
Could someone give me some pieces of advice?
Thanks a lot

 

[wideboydixon]

Dates and times are stored as a number. The integer part represents the date and the decimal part indicates the time. Since one day is 24 hours it means that 08:00 is one third of the way through the day or 0.3333 as you've seen. If you change it to 16:00 that you'll get 0.6666 and 12:00 would be 0.5 etc.

Having said that, you can use the cell value directly:

Application.OnTime Range("A1").Value, "MyProcedure"

This will run your procedure at 08:00 in your case.

WBD

 

[Ploom]

Thanks a lot!
Yes i could use my range directly, thanks, i forgot about this conversion, and i saw somwhere they used timevalue and got confused
Thanks for your help!