Elapsed Time

Here is a simple formula that will calculate the time elapsed over several days.

Here is a simple formula that will calculate the time elapsed over several days. All the fields are date/time....

Begin and End show date and time, Total shows time only

Example:
Begin 06/20/2001 08:20 AM
End 06/20/2001 10:00 AM
Total 49:40

If you only want calculate elapsed time for one day take out the formula for days and hours and make your fields Begin and End show time only.

Begin 08:00 AM
End 13:00 PM
Total 5:00

 Code for Total Field(Computed): days := @If (Begin=""; 0;@day(@Adjust(End;0;0;-@Day(Begin);-@Hour(Begin);-@Minute(Begin);0))); min := @If (Begin=""; 0;@minute(@Adjust(End;0;0;0;-@Hour(Begin);-@Minute(Begin);0))); hour := @If (Begin=""; 0;@hour(@Adjust(End;0;0;0;-@Hour(Begin);-@Minute(Begin);0))); hours := @if(days > 0;days*24;0); @If(Begin = "";0;@If(hour = (min/60); @Text(hour + hours) + ":00"; @Text(hour + hours) + ":" + @Text(min)))
This was first published in June 2001

Dig deeper on Domino Resources - Part 4

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