Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have two Time Value
Time1 Time 2 Difference = Time1 - Time2
10:43:36 AM 10:22:00 AM Ouput Required in Seconds
I am simply Doing Time1-Time2 and Getting output 175.98499988425;
expected output is 21:36 Minutes... Final result want in seconds
Please Suggest
Abhay
Time in minutes:
(Frac(Time1) - Frac(Time2)) * 1440
Time in seconds:
(Frac(Time1) - Frac(Time2)) * 1440 * 60
Try this:
Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 'mm:ss')
=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')
=Interval(Time#('10:43:36 AM','hh:mm:ss tt')-Time#('10:22:00 AM','hh:mm:ss tt'),'mm:ss')
or
=Interval(Time#('10:43:36 AM','hh:mm:ss tt')-Time#('10:22:00 AM','hh:mm:ss tt'),'ss')&' Seconds'
HI,
Not Working
Interval(Time#(Time1Field, 'hh:mm:ss TT') - Time#(Time2Field, 'hh:mm:ss TT'), 's')
regards
Abhay
Hi try this,
Interval(Time#(Time1)-Time#(Time2),'hh:mm:ss') as TimeDiff
See if this is what you want:
Expression: =Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 'mm:ss')
Not sure though but It seems your time fields are of Timestamp type else suggested solution would have worked. May be Try Frac() before Time# function.
Hi Abhay,
Go to Number tab,
Choose the format of Time1, Time2, and Difference (TIme1-Time-2) as Time in Number tab.
Regards,
Pavan.
I m trying below
Interval((Time(DateRecorded_Test, 'hh:mm:ss TT')) - (Time(UTC_World_TIme, 'hh:mm:ss TT')), 'mm:ss')
Regards
Abhay