Duration question

[#1]

Hi all.

I have two date values in the fields 'start' and 'end':

2011-06-27 02:22:00 PM

and

2011-06-27 04:27:30 PM

I want to know how i can calculate the time passed 'start' and 'end' within my LOAD script.

Any ideas ?

[#2]

The following expression will give duration in seconds:

round((end-start)*3600*24,1)

Kiran.

[#3]

Found in other forum:

=Interval(Time(Time#('Start', 'hh:mmtt')) - Time(Time#('End', 'hh:mmtt')), 'hh:mm')

Thank Mugel

Krishna