InfoPath 2010

Re: Working out time difference between two fields.

Travisty2520 — Mon, 30 Jul 2018 15:08:18 GMT

Hello Patrick,

How do I do this if I need them to be Date/Time fields as the errors last over several days I also need it to exclude weekends if possible

Re: Working out time difference between two fields.

Patrick Halstead — Sun, 10 Mar 2013 18:52:36 GMT

The horrid red bold dotted line is because the field is a date-time when you just want time. Double click the fields in the taskpane and change from date-time to just time.

You should be able to just remove the colon from the time using translate(field,":","") and then subtract one from the other. So, if field1 and field2 are time formats and you want field3 to be the difference (where field3 is a number). Just double click field3 and add a default value that is something like this: translate(../my:field2, ":", "") - translate(../my:field1, ":", "").

Working out time difference between two fields.

Zeb Ahmed — Sun, 03 Mar 2013 19:45:56 GMT

Hello all, I have three fields in a form:

StartTime
EndTime
Duration

I'm trying to calculate in the Duration field the time difference between the times entered in StartTime and EndTime.

e.g. If StartTime is 15:00 and EndTime is 15:30 the Duration field should populate with 00:30

Except I can't figure out how to do this, and the one link I found on here: http://www.infopathdev.com/forums/p/18516/66036.aspx

KINDA works, but for some reason puts a horrid red bold dotted line around the Duration field. I don't know why it's doing this because there are no rules on that field that would cause this.

Help?

I've tried several guides but can't figure it out.. really the above link was the closest to working for me, except for that horrid red dotted line.

This confused the *beep!* out of me :(
http://blogs.msdn.com/b/infopath/archive/2007/02/21/calculating-elapsed-time-without-code.aspx

This made sense as it was step by step, but it was written for InfoPath 2003, and even after giving it a go, it did not work.
http://www.bizsupportonline.net/infopath2003/time-calculations-infopath-using-rules.htm

I tried to use the following formulates but InfoPath errored on them:
=TEXT([Column2]-[Column1],"h:mm")
and
=INT(([Column2]-[Column1])*1440)
(with the columns matching the names of my columns; formula applied to the field (default value) that will display the difference)
Found on this page:
http://msdn.microsoft.com/en-us/library/bb862071.aspx

I'd just like to find a step by step guide that shows me how to do this. Help? :)