G Guest Oct 12, 2004 #3 Thank you! Sorry about posting twice - I got an error the first time saying it didn't accept it.. Paige Rick B said: DateAdd("n", -300,[MyTimeField]) or DateAdd("h", -5,[MyTimeField]) Paige said: How do I subtract 5 hours from a time field? It is in 24 hours format - Click to expand... Click to expand...
Thank you! Sorry about posting twice - I got an error the first time saying it didn't accept it.. Paige Rick B said: DateAdd("n", -300,[MyTimeField]) or DateAdd("h", -5,[MyTimeField]) Paige said: How do I subtract 5 hours from a time field? It is in 24 hours format - Click to expand... Click to expand...