This content has been marked as final. Show 2 replies
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')