Hi all,
I had a Time From field and Time To field for user to fill in. Both of them are Date/Time format. After users filled in the value, my application check the time difference between this 2 fields in view.
In view, my formula very straight forward to just get the time difference by TimeTo-TimeFrom.
However, i got a problem on a document where user fill in TimeFrom = 10:00 PM, TimeTo = 12:00 AM.
Supposely the difference is 2hours. But instead of getting 2 hours, system appear error. How can I solve this?
Thanks.