Found this weird interaction, where a cell value is 12:00PM, and when a userform pulls the value into a combobox it is read as 0.5, and when the format is changed to h:mm it gives 12:05AM in the combo box.
I have found that 6:00AM also translates to 12:25AM, I have checked every time increment of 15 minutes and only those two times seem to return anomolies.
I have used if statements to convert the values back to their desired time, but I am extremely curious as to what is going on inside of excel for these values to act like this.
Any insight is appreciated.
I have found that 6:00AM also translates to 12:25AM, I have checked every time increment of 15 minutes and only those two times seem to return anomolies.
I have used if statements to convert the values back to their desired time, but I am extremely curious as to what is going on inside of excel for these values to act like this.
Any insight is appreciated.