Have a look at a [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=001329#000001"]similar discussion on duration calculations[/url].
If you create calculated fields to get Date/Time fields for the Calc Start Time:
[font="courier"]ctod(,"y/m/d","DT") /font[/quote]and the Calc End Time:
[font="courier"]ctod(EndTime,"y/m/d","DT") /font[/quote]you can then calculate the duration in seconds:
Just subtract one D&T field from the other and multiply by 86400.
If you set the resulting field to numeric and general format you will get seconds. If you set its format to timespan you will get hh:mm:ss
The calculation of the difference between the dates and times gives a result in days and decimal portions of days. Multiplying by the number of seconds in a day gives the answers in seconds.
Or Kruncher's version of course if the Date and Time do not start out in a "date and time" field type.
Edit to observe that Todd beat me to it! :cool: