convert to seconds

[#1]

hi guys, i want to convert 12:15:44 to seconds how can i do that

thanx.

[alexandros17 · Accepted solution]

hour('12:15:44')*3600+minute('12:15:44')*60+second('12:15:44')

let me know

[MK_QSL]

=Time('12:15:44')*24*60*60

[#4]

Num('12:15:44') * 86400

This converts your time field to a number which represents the fraction of a day (0.51092592592593)

Then multiply by 86400 because there are 86400 seconds in a day

[its_anandrjs]

Try this also in any text object

=Second( Time('12:15:44')) +

  Minute( Time('12:15:44')) * 60 +

  Hour( Time('12:15:44')) * 60 * 60

[#6]

Thank you guys, all the solutions that you have suggested are correcte.

[alexandros17]

... could you please give marks??

[#8]

Try Interval('12:15:44','s')) for a more simplistic solution keep in mind that you need the date to have the right format.