Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys, i want to convert 12:15:44 to seconds how can i do that
thanx.
hour('12:15:44')*3600+minute('12:15:44')*60+second('12:15:44')
let me know
hour('12:15:44')*3600+minute('12:15:44')*60+second('12:15:44')
let me know
=Time('12:15:44')*24*60*60
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
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
Thank you guys, all the solutions that you have suggested are correcte.
... could you please give marks??
Try Interval('12:15:44','s')) for a more simplistic solution keep in mind that you need the date to have the right format.