How can i get the time in hour minute & second by substracting 2 Date/Time Field

How can i get the time in hour minute & second by substracting 2 Date/Time Field.

plz help me out thanx in advnce.

waiting 4 yr reply

Subject: How can i get the time in hour minute & second by substracting 2 Date/Time Field

Hi,

difference& = notesDateTime.TimeDifference( notesDateTime )

or

difference# = notesDateTime.TimeDifferenceDouble( notesDateTime )

finds the difference in seconds between one date-time and another (NotesDateTimeClass)

Now compute the days, hours, minutes and seconds…

HTH Oliver

Subject: How can i get the time in hour minute & second by substracting 2 Date/Time Field

a:=@If(SF_NextCall_Time!=“”;SF_NextCall_Time-SF_Info_Receive_Time;“”);a;

b:= @Integer(a/3600);

@If(SF_NextCall_Time!=“”;@SetField(“Hour”;@Text(b));“”);

c:=@Modulo(@Integer(a);3600);

d:= @Integer(c/60);

@If(SF_NextCall_Time!=“”;@SetField(“Minute”;@Text(d));“”)

by this i have solved the problem u can refer it