Difference in Time

HCL Domino Domino Forum
1

Hi,

I have two date/time fields, in which i display time. I want to find the difference between those two times. Can anyone help me on this.

Thanks in advance

2

Subject: Difference in Time

Suppose you want to find out the difference in seconds between FieldA and FieldB, you can use:

@If (FieldA=“” | FieldB=“”; “”; FieldA- FieldB),

If you want to find out the difference in hours, then use (FieldA- FieldB)/3600; in days, (FieldA- FieldB)/86400.

Good luck!