NateW
01-16-2008, 09:46 AM
Hi, Folks.
I'm looking for a way to get a listing of various time values for use in vba time calculations - I'm not sure what the proper name of this is, but it's the numeric value that is stored for dates and times - where each calendar day starting from 1899 or something has a whole number value, and the hours and minutes, etc, have a decimal value.
Does anyone know if there is a reference anywhere that will show various values? Or, alternately, is there a way in excel to display the time values with code, to create a reference list of my own?
Thanks in advance for any help - please let me know if you need any further clarification.
Cheers!
Nate. :hi:
I'm looking for a way to get a listing of various time values for use in vba time calculations - I'm not sure what the proper name of this is, but it's the numeric value that is stored for dates and times - where each calendar day starting from 1899 or something has a whole number value, and the hours and minutes, etc, have a decimal value.
Does anyone know if there is a reference anywhere that will show various values? Or, alternately, is there a way in excel to display the time values with code, to create a reference list of my own?
Thanks in advance for any help - please let me know if you need any further clarification.
Cheers!
Nate. :hi: