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? :)