Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone
I want to calculate time difference.
It is calculating right but if the date is changed then it has problem.
You can see the second last row from the snapshot.
I have 4 fields in database startdate, starttime, enddate, endtime.
I want result 3:00 in second last row.
I have used this
=Interval (endtime - starttime, 'hh:mm')
Hi
Please try with this:
=IF(END_TIME>=START_TIME,
Interval(END_TIME-START_TIME,'hh:mm:ss'),TIME(Interval#('24:00:00','hh:mm:ss')-Interval(START_TIME-END_TIME,'hh:mm:ss'),'hh:mm:ss')
)
Hi
Please try with this:
=IF(END_TIME>=START_TIME,
Interval(END_TIME-START_TIME,'hh:mm:ss'),TIME(Interval#('24:00:00','hh:mm:ss')-Interval(START_TIME-END_TIME,'hh:mm:ss'),'hh:mm:ss')
)
Thanks Sumanta