How can I calculate elapsed time on a Report

[Steve in Atlanta]

When calculating elapsed time between two times in military format I have problems if one of the times is before midnight and the other is after. For instance, if the start time is 23:48 and the end time is 00:59 the elapsed time is 1:11. It is displaying as 22:49. Also, how can I get it to display seconds as well (hh:mm:ss)

 

[bat17]

To displsy in HH:MM:SS use the formst hh:nn:ss

As for the problem of running into more than one day then you realy need to use a date/time stamp. If you are sure that the period will never exceed 24hrs you could construct an if statement to add 24hrs if the second time is smaller than the first time though.

Peter