Calculating Time

[nancy]

I would like to caluclate the total minutes using this formula
Diff ("n", [StartDateTime], [EndDateTime]), But I don't know where to put it.

 

[Beetle]

The function is DateDiff;

DateDiff("n", [StartTime], [EndTime])

You could put it in;

1) A calculated field in a query

2) A calculated control in a form or report

3) VBA code

 

[Tom Wickerath]

To add some to Sean's answer, here are links to three articles that you may
find helpful:

Functions for calculating and for displaying Date/Time values in Access
http://support.microsoft.com/kb/210604

On time and how much has elapsed
http://office.microsoft.com/en-us/access/HA011102181033.aspx

Using dates and times in Access
http://office.microsoft.com/en-us/access/HA010546621033.aspx


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

The function is DateDiff;

DateDiff("n", [StartTime], [EndTime])

You could put it in;

1) A calculated field in a query

2) A calculated control in a form or report

3) VBA code

--
_________

Sean Bailey

__________________________________________

:

I would like to caluclate the total minutes using this formula Diff ("n",
[StartDateTime], [EndDateTime]), But I don't know where to put it.