Calculate 30 minutes earlier

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!
 
Perfect!

Thank you!

KARL DEWEY said:
Adjusted Time: DateAdd("n", -30, [YourDateField])

--
Build a little, test a little.


Tim said:
Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!
Click to expand...
Click to expand...
 
Back
Top