when my users travel, I need to record the time it takes from departure to arrival.
I have all the code to handle this if my users depart and arrive on the same day. I run into an issue when they depart one day and arrive the following.
if user a departs 10/20/2012 at 23:05 and arrives 10/21/2012 at 11:10 their elapsed time is 12 hours (rounded to nearest quarter hour). when I try to run this through my code i get a negative result and the program crashes. How do I handle this type of event?