ExpressionHelp

[abhaysingh]

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

[Gysbert_Wassenaar]

Try interval(Field1-Field2, 's')

[abhaysingh]

No change in data..still getting  3:31:31 PM

[abhaysingh]

Sory getting this number output

-15020907

thanks

[jonathandienst]

This is a duplicate of Exp Help

[#6]

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)

[pratap6699]

=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