I'm desperate to know if anybody has an answer re: how to perform cacluations on date/time fields for times that run over midnight. Here's an example for calculating duration of time for "treatment":
Treatment Start Time (Field: time_tx_start): 10/1/2002 @ 23:59
Treatment End Time (Field: time_txend): 10/2/2002 @ 01:02
The query I have set up to determine length of tx duration is as follows:
tx_duration: DateDiff("n",[time_tx_start],[time_txend])
However, for the previous example, this query gives me the following 4-digit #:
-1377
I have then been converting this # in excel by adding 1440 (the number of minutes in 1 day), to get the true treatment duration time of 63 minutes. Free Enron stock to anyone who knows of a less cumbersome way!! (Just kidding), but I would be very greatful!!
Treatment Start Time (Field: time_tx_start): 10/1/2002 @ 23:59
Treatment End Time (Field: time_txend): 10/2/2002 @ 01:02
The query I have set up to determine length of tx duration is as follows:
tx_duration: DateDiff("n",[time_tx_start],[time_txend])
However, for the previous example, this query gives me the following 4-digit #:
-1377
I have then been converting this # in excel by adding 1440 (the number of minutes in 1 day), to get the true treatment duration time of 63 minutes. Free Enron stock to anyone who knows of a less cumbersome way!! (Just kidding), but I would be very greatful!!
