B
Belinda7237
I have a start time and a complete time in a form to calculate how long it
takes for the form entry. I am using the Now formula in a command button to
get the date and time and it is stored as start time and completion time in a
table.
In a query I want to calculate how long it takes for each record.
DateDiff("n",[start time], [completion time]) isnt working for me.
1) What is the correct formula for this calculation?
2) how do i also get the average completion time for all records?
3) I also want to be able to just select a date range to perform this
calculation ie. Can i use a form or report and enter criteria for the month
of January, feb, March and see what the average completion time is by month,
by week etc?
Thanks!
takes for the form entry. I am using the Now formula in a command button to
get the date and time and it is stored as start time and completion time in a
table.
In a query I want to calculate how long it takes for each record.
DateDiff("n",[start time], [completion time]) isnt working for me.
1) What is the correct formula for this calculation?
2) how do i also get the average completion time for all records?
3) I also want to be able to just select a date range to perform this
calculation ie. Can i use a form or report and enter criteria for the month
of January, feb, March and see what the average completion time is by month,
by week etc?
Thanks!