How to calculate time difference in different date?

Hi @Kal_Lam
How to calculate time difference in different date?
E.g:

  • Time of departure= 11:00 PM
  • Time of arrival= 2:00 AM

@novaraseno, you should be able to do this as outlined in the image shared below:

In the survey tab of your XLSForm:

Data entry screen as seen in Enketo:

Reference XLSForm:

Time Difference.xls (32.5 KB)