PaquettePaul
Member
- Local time
- Today, 04:49
- Joined
- Mar 28, 2022
- Messages
- 107
In my current setup for an aircraft flight, the user enters a wheels up time and a wheels down time. I currently use a 24 hour clock time in that the user enter 22:20 for 10:20 PM including the entry of the colon. A change has been requested that the system allow for the entry of military time which would call for the entry of a 4 digit number from 0000 to 2359 without the entry of a colon and of course ensuring that the user does not specify a time between xx60 and xx99. After entry, I need to find the difference between the two times in minutes which causes a problem in that 1345 to 1423 is 38 minutes rather than 78 if i did a straight subtraction between the two values. I will have to change the database field definitions from a date-time field to a numeric field (or a text field) as well.
I could create a bunch of code to deal with this. However, I was wondering whether someone has run across this issue and has a simple soultion,
thanks
I could create a bunch of code to deal with this. However, I was wondering whether someone has run across this issue and has a simple soultion,
thanks