Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to Calculate time diff .
Ex: To-From as Duration
Thanks,
Krishna
PFA!
=interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')
Regards,
AS
PFA!
=interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')
Regards,
AS
Hi Amit,
How to Calculate 24 - interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss')
Thanks,
Krishna
Like this???
=interval(time('24:00:00', 'hh:mm:ss')-
interval(time([ To ], 'hh:mm:ss') - time([From ], 'hh:mm:ss'), 'hh:mm:ss'))
Thanks,
AS