Text to time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone suggest an expression to convert two digit text numbers to
Date/Time format in hours? ie; 12 = 12 hours. I am using this field working
with Doug Steele's Diff2Dates expression. Thank You.
 
Access Date/Time field does not store Hours. It stores time of day as a
decimal fraction of a day.
Like --
HOUR NUM
3:00:00 AM 0.125
4:00:00 AM 0.166666666666667
5:00:00 AM 0.208333333333333
6:00:00 AM 0.25
7:00:00 AM 0.291666666666667
8:00:00 AM 0.333333333333333
9:00:00 AM 0.375
 
I have a two field table with a record for each hour of age from 6 to 120
(Text Format) and a corresponding numerical lab value (Currency Format)
XX.XX. This is a static data set.

I import live data, lab values, Dates and Times and use the Diff2Date
expression to give me the age in hours for each lab value.

My goal is to flag all the live lab values greater than the value listed in
the static data set for the given age in hours.

Maybe I should convert the age in hours to a straight numeric value to
compare with the static data set.

Any ideas or guidence on this will be appreciated. Thank You
 
Your formats seem to be non-capatible --
Text field having numbers
Numerical labor value in currency format.

I am not familiar with Date2Diff function, only DateDiff.
DateDiff("h",[FirstDate],SecondDate]) give hours in whole numbers.
 
Back
Top