Time Difference

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.

Subject: Time Difference

Hi Edeline,

I checked with the same context as like u mentioned.I got result of -22 .this is also not a correct value .i think it may be lotus bug. please any one help us on this issue?

Thanks & regards

Karthik.C