Convert time into minutes

[#1]

Hi everyone,

I have a field name arrival_time in the format hh:mm:ss.

I am looking to convert into minutes.

Regards,

Kv.

[nagaiank]

You may try Interval function.

For example, interval(Time#('01:00:00','hh:mm:ss'),'mm') gives 60

[er_mohit]

hay use this function in might be helps to you...

= interval(Time#(arrival_time,'hh:mm:ss'),'mm') &  ' minutes '

regards

Mohit