AnsweredAssumed Answered

Help with military time

Question asked by chrisbouse on Aug 24, 2012
Latest reply on Aug 24, 2012 by chrisbouse


Help with military time


I am doing a simple time calculation but for some reason I can not figure this out. Can someone PLEASE help me!!!

I have two fields, "Start of Watch" and "End of Watch". Both fields types are set as time. I have both fields set to display in military time.

I need to take the "Start of Watch" time and add 10 hours to it and have it automatically populate the "End of Watch" time with the end result. I did a simple calculation to accomplish this;

In the End of Watch field: Start of Watch + 36000

Though the field displays the time properly, once you click in the field it displays the seconds. I cant have the seconds display in the "End of Watch" field as i am using the fields value in some forms. Every time i do any sort of calculation with time it adds the seconds. I cant find a formatting option to tell it not to display the seconds.

Please end my misery and help me....