I have a simple for that has a button that stores a Starttime and an endtime. I need to run a report that shows the total time for that record. I am currently using the following:
=DateDiff("n",[end time],[start time])/60
but for a record that has a start time of 8/24/2006 10:39:15 AM and an end time of 8/24/2006 10:40:15 AM it calculates as 0:24 instead of one minute can anyone help as im sure im just not doing something right.
Thanks!
Paul
=DateDiff("n",[end time],[start time])/60
but for a record that has a start time of 8/24/2006 10:39:15 AM and an end time of 8/24/2006 10:40:15 AM it calculates as 0:24 instead of one minute can anyone help as im sure im just not doing something right.
Thanks!
Paul