Time calculations

[skynight]

Sirs, how would I do a calculation for the time difference between two entered fields, such as Start Time, End Time? I have tried to make such a calculation, by making the start and end time values TIME, but the result makes no sense. It thinks the time value, for the 24 hour clock, is minutes. It will not display the time normally, but puts the : mark after the minutes and then adds seconds, thus 1630 is displayed as 1630:00, which must have something to do with the calculation. I cannot enter the times as numbers since the calc will be totally wrong. I do not want to use the 12 hour clock, but will if this is the only way to do it. And if the two times are on different days (start time 2200 day one, end time 0300 day two for example) how would the program know that?

Thanks in advance, Glen

[Raybaudi]

And if the two times are on different days (start time 2200 day one, end time 0300 day two for example) how would the program know that?

Hi

you have to use two TimeStamp fields as TimeStart and TimeEnd

TimeEnd - TimeStart, result as Time will give you the exact time elapsed in this format:

hh:mm:ss

[comment]

Using Timestamps for entry is better, but not mandatory. Try:

EndTime - StartTime + ( EndTime < StartTime ) * 86400

The result should be set to Time. This assumes that the elapsed time is less than 24 hours in total, so when starting time is later than ending time it adds 24 hours to the end.