Calculate 30 minutes earlier

's Computer Specifications

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!

's Computer Specifications

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

--
Build a little, test a little.

"Tim" wrote:

> 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!

's Computer Specifications

Perfect!

Thank you!

"KARL DEWEY" wrote:

> Adjusted Time: DateAdd("n", -30, [YourDateField])
>
> --
> Build a little, test a little.
>
>
> "Tim" wrote:
>
> > 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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to calculate the number of dates in a column earlier than toda	IGG	Microsoft Excel Worksheet Functions	2	10th Mar 2008 04:08 PM
How do i Calculate minutes between two different dates	=?Utf-8?B?QWxp?=	Microsoft Excel Misc	5	13th Sep 2007 04:28 PM
how do I calculate minutes when given two times?	=?Utf-8?B?S2luYQ==?=	Microsoft Excel Worksheet Functions	2	17th Jun 2006 04:38 AM
how do i calculate minutes between two times?	=?Utf-8?B?Um9u?=	Microsoft Excel Misc	5	2nd Feb 2005 01:39 AM
Using DateDif to calculate minutes	=?Utf-8?B?Sm9l?=	Microsoft Excel Worksheet Functions	4	21st Oct 2004 11:20 AM