Calculate Date Time Difference in Hours in InfoPath 2010

Question

0.00/5 (No votes)

See more:

SharePoint2010

I'm currently looking for a way to get the difference between 2 date time fields in hours. The first "Start Time" is a date time field with its default value as now() while the "End time" is a also a calculated field. The "end time" field is to be populated when the form has concluded its workflow process. i.e. "Start time" picks the time the form is opened by the initiator while "end time" picks the current time as at time of final approval.

Kindly assist on how I go about getting the difference between these two fields.

I have followed the steps on this blog but I get a "NaN" value on both the StartTime and EndTime fields.

http://blogs.msdn.com/b/infopath/archive/2007/02/21/calculating-elapsed-time-without-code.aspx?PageIndex=3[^]

Kindly assist on how I go about getting the difference between these two fields.

Thanks.

Part 2 Question

Hi, this time difference works perfectly for activities that last within the same day. My client has requested for a time calculation that will span across 2 days e.g. if a task(db backup) starts 9pm on Thursday 30th April 2015 and ends 9am on Friday 1st of May 2015.

Any ideas on how I implement this?

Thanks.

Posted 27-Apr-15 0:09am

BamideleAriwodola

Updated 30-Apr-15 4:22am

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2015-04-27T00:49:00

Solution 1

Have a look here:
Calculating Time Differences in InfoPath Without Custom Code[^]
Calculating Elapsed Time…without code![^]

Posted 27-Apr-15 0:49am

Maciej Los

Comments

BamideleAriwodola 27-Apr-15 7:44am

Thank you.
The 2nd blog post eventually worked.

Maciej Los 27-Apr-15 7:58am

You're very welcome ;)

BamideleAriwodola 30-Apr-15 10:21am

Hi, this time difference works perfectly for activities that last within the same day. My client has requested for a time calculation that with span across 2 days e.g. if a task(db backup) starts 9pm on thursday 30th April 2015 and ends 9am on friday 1st of May 2015.
Kindly assist on how I go about implementing this requirement.

Thanks.