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
>>175.98499988425
There are 176 days between these two timestamps. Are you sure the simple difference in minutes is meaningful?
by differenciate time interals we use interval function
=Interval(Time#('10:43:36 AM', 'hh:mm:ss TT') - Time#('10:22:00 AM', 'hh:mm:ss TT'), 's')