# Elapsed Time

## Domino Resources - Part 4

### Looking for something else?

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 last published in June 2001

#### Start the conversation

Send me notifications when other members comment.

## SearchWindowsServer

• ### Creating PowerShell scripts for task automation

At a certain point, administrators who run PowerShell commands from the console will find it more efficient to develop a script ...

• ### Windows Defender Credential Guard secures login data

Windows Defender Credential Guard uses virtualization to isolate access to domain credentials and diminish the threat of attacks ...

March Patch Tuesday adds several more mitigations for the Spectre and Meltdown exploits, this time for 32-bit server and client ...

## 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 ...

## SearchDataCenter

• ### IBM Cloud services to secure mainframes out to the edge

Big Blue will introduce IBM Cloud services that use blockchain, containers and its z14 mainframes to deliver improved security ...

• ### Four disadvantages of hyper-converged infrastructure systems

Problems with scalability and unexpected licensing costs can create problems for organizations that deploy hyper-converged ...

• ### IBM Power9 servers seek market inroads to AI, cloud

IBM follows up its first Power9 server with a raft of systems designed to appeal to a wider array of markets -- most notably, AI ...

## SearchExchange

• ### Using Microsoft Exchange certificates requires planning

Exchange certificates typically require minimal management effort after they have been set up, and they offer a secure means of ...

• ### Office 365 email encryption options grow for enterprise needs

Each enterprise has different needs when it comes to preventing data leakage. Admins should be aware of the Office 365 mailbox ...

Everyone wants a smooth patching process, but things can fall apart despite everyone's best efforts. Develop a solid recovery ...

## SearchContentManagement

• ### Box CEO weighs in on Dropbox IPO, AI in content management

In a wide-ranging conversation, Box CEO talks about Dropbox's public offering, AI's next application for content, Salesforce ...

• ### Scrivito unveils serverless CMS product

By building the CMS with ReactJS, Scrivito gained attraction with development community, according to an analyst.

• ### Content personalization tools sharpen focus on customers

Content personalization isn't new; Amazon weaponized it, and Jeff Bezos is the world's richest man. New tools are putting it ...

Close