Time

[Guest]

Thank you

Table has a field named TIME, no date.
Datatypeate/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

 

[Guest]

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

 

[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.