Time

J

Jay

Thank you

Table has a field named TIME, no date.
Datatype:Date/Time
Format: 16:24:45 in 24 hour format

Please, help me to substract TIME by 7 hours using query.
Example: 16:24:45 to 9:24:45
 
K

KARL DEWEY

Time is stored as a decimal fraction of a day. One hour is 1/24 or
0.0416666666666667 and 7 times that is 0.291666666666667
 
D

Douglas J. Steele

While that's true, what's wrong with DateAdd("h", -7, [Time])?

Jay: I'd strongly advise renaming your field. Time is a reserved word, and
should never be used as a name for any of your own objects.
 
Top