G
Guest
I have searched this site & Google groups for the solution to my problem &
have found info on the subject, but I have not been successful in
implementing in my query. I am sure the solution is simple but I am a
novice.
Here's my problem & thank you in advance for your help.
I have a query with StartTime & EndTime fields. I created a calculated
field using the following expression (from Allan Browne's site) to calculate
the Elapsed Time in minutes: Minutes: DateDiff("n", [StartDateTime],
[EndDateTime]), however, I am getting negative numbers when my EndTime is
after midnight of the next day.
example:
StartTime=11:50:00 PM
EndTime= 12:00:00 AM
ElapsedTime= -1430
All dates within the same 24 hr period return the correct number of minutes.
have found info on the subject, but I have not been successful in
implementing in my query. I am sure the solution is simple but I am a
novice.
Here's my problem & thank you in advance for your help.
I have a query with StartTime & EndTime fields. I created a calculated
field using the following expression (from Allan Browne's site) to calculate
the Elapsed Time in minutes: Minutes: DateDiff("n", [StartDateTime],
[EndDateTime]), however, I am getting negative numbers when my EndTime is
after midnight of the next day.
example:
StartTime=11:50:00 PM
EndTime= 12:00:00 AM
ElapsedTime= -1430
All dates within the same 24 hr period return the correct number of minutes.