Conversion of time

[#1]

Hi,

I have a field in my table "Time_Duration" as EX- '00:00:15' , '00:02:11', '01:12:40'.

I want to calculate duration in seconds like 15 , 131 seconds etc from above format..

Please post your Ideas.

Thanks,

Arun

[swuehl]

If you want to keep the underlying format, just display as seconds:

=interval( Time_Duration, 'ss')

If you wan to convert the time to a an integer showing seconds:

=num#(interval( Time_Duration, 'ss'))

(Difference will be more relevant when you perform subsequent calculations with the resulting values)

[sasiparupudi1]

load Time_Duration ,

interval(Time_Duration,'ss') as Time_DurationSeconds

inline

[

Time_Duration

00:00:15

00:02:11

01:12:40

];

Please close the thread if you got your answer