Difference Between Two Dates In Hours:Min:Sec

This simple formula will find the difference between two dates in
Days/Hours/Min:
s:=(Date2 - Date1);
m:=s/60;
h:= m/60;
days := @Integer(h/24);
d1:= @Modulo(h;24);
h1:=@Integer(h);
min1:=@Modulo(m;60);
sec1:=@Modulo(s;60);
result:=@If(days=0;@Text(d1)+" hrs "+ @Text(min1)+" mins";@Text(days)+" days
"+@Text(d1)+" hrs "+ @Text(min1)+" mins");
result
This was first published in November 2000

Dig deeper on Lotus Notes Domino Administration Tools

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close