Calcualting Time

Recommended Posts

I have 2 fields that are times(start time and end time) I also have a total time field. The first 2 are set as "11:00 PM" and I want the total time field to show the total time without the "am/pm". How do I make it do that?

Share this post

Link to post

Share on other sites

The Total Time field should be a calc with the result type Time. Then format that field using 24-hour notation. It will show the time in the format: 8:00:00 (or whatever bits you wish to include in the format).