I have time entry split into 3 fields, Hour, Min and Am or PM
Why not use a single field of type time? What do you gain by using separate fields?
a calculation of Hour * 3600 + Min * 60 + 12 * 3600 * ( AmField = "PM" )
with Time as the selected result type should work.
Time fields are really number fields that record the number of seconds since midnight. (There are 3600 seconds in an hour)
Thanks PhilModJunk works beautifully.
F.Y.I i use 3 fields because it takes the guess work out of entering the time for the users. instead of trying to get them to enter the time as HH:MM AM or PM I just have a drop down box for each Hr, Min and AM field, 1-12 for hour, 15, 30, 45, 00 for Min and AM or PM. Accounts for not so bright employees