How to display a maximum time value

[VideoDave2665]

I could use a little help in getting a maximum time value to display correctly.

In a form I have several ENDTIME values where I want to have a field look at the list (ENDTIME0, ENDTIME1, ENDTIME2, ENDTIME3, ENDTIME4, ENDTIME5) and display the highest value in the field ENDDEPOSITIONTIME.

In ENDDEPOSITIONTIME, I have the Calculation Value to look at all of the EndTimes listed above and I'd like to see the highest value displayed.

• All of the ENDTIMEx have the format as h:MM tt so they display as 4:08 pm.
• ENDDEPOSITIONTIME when formatted as h:MM tt, throws an error "The value entered does not match the format of the field ENDDEPOSITIONTIME" 
• When I change the format to NONE, the result I get is 4.08. That's the correct answer for this example, but the format is not correct. The result does not have the colon or the am/pm.

Any help would be appreciated for this newby Javascript writer.