I have a time totaling variable (declared as type Date) which I use
to implement a running total of time (hours and minutes).
I put a Watch on the variable to see what happens as the total moves
towards 24:00, and lo and behold, when the total gets to over
23:59:59 it goes into a mixed date + time format with the time being
truncated to a remainder (modulus) of 24. The date shown is 31-Dec-
1899.
When I assign from the Date type variable into a String type
variable, I get exactly that date in the string, i.e., with the "31-
Dec-1899" hh:mm:ss.
Is there any way to fix this? Like applying a mask/format to the Date
variable? Or a masked/formatted conversion to the string?
Or will I have to convert to integers and manage a structure with two
components { Hours as Integer, Minutes As Integer }? Ugggghhhh!!!
Or keep the total as a floating point number?