Subtract 2 dateTime stamps

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I am collecting data for a call center. They now want to measure the time
on a call in minutes. So I can collect the beginning time as Stamp1 and the
ending time as Stamp2. I am using the now() function to collect the data.

How do I subtract the 2 fields and get minutes as a number value?

Thanks

Dave
 
Thanks!

What is the significance of the "n"?

Dave

Duane Hookom said:
Use an expression like:
=DateDiff("n", [StartTime], [EndTime])

--
Duane Hookom
MS Access MVP
--

Dave said:
I am collecting data for a call center. They now want to measure the time
on a call in minutes. So I can collect the beginning time as Stamp1 and
the ending time as Stamp2. I am using the now() function to collect the
data.

How do I subtract the 2 fields and get minutes as a number value?

Thanks

Dave
Click to expand...
Click to expand...
 
DateDiff can calculate years, months, days, hours, minutes, or seconds. The
first argument tells the function which one you want returned. Since M is used
for months, it cannot also be used for minutes. MS programmers decided to use N
for minutes. If you wanted more accuracy, you could use S for seconds and then
divide by 60 to get minutes and fractions of minutes.
Thanks!

What is the significance of the "n"?

Dave

Duane Hookom said:
Use an expression like:
=DateDiff("n", [StartTime], [EndTime])

--
Duane Hookom
MS Access MVP
--

Dave said:
I am collecting data for a call center. They now want to measure the time
on a call in minutes. So I can collect the beginning time as Stamp1 and
the ending time as Stamp2. I am using the now() function to collect the
data.

How do I subtract the 2 fields and get minutes as a number value?

Thanks

Dave
Click to expand...
Click to expand...
Click to expand...
 
Back
Top