Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
I have one Field in which i am getting Value in Below Format
Field1 Field2 Output(Wants in Second)
28-09-15 04:46:52 PM 28-09-15 01:15:20 PM 3:31:31 PM (How i can convert it into seconds)
Please Suggest
Thanks
Abhay
Try interval(Field1-Field2, 's')
No change in data..still getting 3:31:31 PM
Sory getting this number output
-15020907
thanks
This is a duplicate of Exp Help
is the time that is stored contain seconds? If seconds are not part of the field you will not be able to get accurate seconds (I do not believe)
=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')
to convert sec's as well as minuts and hours and days also by using interval function