		Site Navigation
	Home
	Products
	Tags
	Levels
	Dates
	Authors

		5 MOST RECENT
	Click to view Braintrove article: Perform a Case-Insensitive String Comparison without Using Translate() Written by Gregory Scot Collins Thursday, 20 August 2009, 7:21 PM Products: InfoPath and Office Hidden in undocumented optional parameters of an extended function, there is a way to perform a case-insensitive string comparison without the need for the translate() function. Perform a Case-Insensitive String Comparison without Using Translate()
	Click to view Braintrove article: Force a Field Value to a Boolean Using Rules Written by Gregory Scot Collins Wednesday, 29 July 2009, 9:42 AM Products: InfoPath and Office Custom data validation is not available for fields bound to a secondary data source making it a challenge to validate to a specific data type. Using rules you can force a field value to a Boolean. This is especially useful when standardizing unconventional Boolean values copyied from a secondary data source. Force a Field Value to a Boolean Using Rules
	Click to view Braintrove article: Quickly Crop to a Shadow Written by Gregory Scot Collins Friday, 29 May 2009, 8:55 AM Product: Photoshop Learn how to crop to a shadow perfectly in a few seconds without the need to fuss with zoom and look for slight color variations. Quickly Crop to a Shadow
	Click to view Braintrove article: Preview and Open Forms after Upgrading to Internet Explorer 8 Written by Gregory Scot Collins Friday, 10 April 2009, 12:29 PM Products: InfoPath, Internet Explorer, Office, Visual Studio, Visual Studio Tools for Applications, Visual Studio Tools for Office and Windows After upgrading to Internet Explorer 8 you might find that you can no longer preview or open your managed code forms. There is an easy solution to this. Preview and Open Forms after Upgrading to Internet Explorer 8
	Click to view Braintrove article: Eliminate NaN and Infinity Errors in Calculations Written by Gregory Scot Collins Tuesday, 31 March 2009, 11:52 AM Products: InfoPath and Office Calculation errors are useful, but not always desirable. This simple technique will show you how to replace NaN and Infinity errors with a zero or blank value. Eliminate NaN and Infinity Errors in Calculations

		5 MOST POPULAR
	Click to view Braintrove article: Pass Query String Parameters to an ASP.NET Xml Control Written by Gregory Scot Collins Friday, 19 May 2006, 5:19 PM Product: ASP.NET Use the Page_Load method of your ASPX page to attach a list of parameters to your asp:Xml control that will be passed through to your XSL transform. Pass Query String Parameters to an ASP.NET Xml Control
	Click to view Braintrove article: Access a Method in a Master Page with Code-Behind Written by Gregory Scot Collins Friday, 16 June 2006, 7:09 AM Product: ASP.NET Write code for pages with code-behind to access a method in an immediate or parent master page from a content page. Access a Method in a Master Page with Code-Behind
	Click to view Braintrove article: Prevent Namespace Prefixes from Being Copied to the Output Written by Gregory Scot Collins Monday, 1 May 2006, 7:18 AM Products: HTML, JavaScript, XML, XPath and XSLT The extra namespace prefixes required to transform XML are not always desirable on the output. This article describes a technique for excluding specific namespace prefixes from the output. Prevent Namespace Prefixes from Being Copied to the Output
	Click to view Braintrove article: Create Groups in a Drop-Down List Box Written by Gregory Scot Collins Saturday, 17 June 2006, 5:57 AM Products: CSS, FireFox, HTML and Internet Explorer Create grouped option-sets in your drop-down list boxes, each with its own non-selectable header. Create Groups in a Drop-Down List Box
	Click to view Braintrove article: Change the Default Action of the Power Button on the Windows Vista Start Menu Written by Gregory Scot Collins Friday, 8 December 2006, 5:30 AM Product: Windows In Windows Vista, you can change the default action for the power button on the Start menu, as well as for other power events, in the advanced power settings. Change the Default Action of the Power Button on the Windows Vista Start Menu

		5 MOST FORGOTTEN
	Click to view Braintrove article: Install Windows 7 Beta onto a Virtual Machine Written by Gregory Scot Collins Wednesday, 25 February 2009, 9:52 AM Products: Virtual Server and Windows Walk through the simple process of installing Microsoft Windows 7 Beta onto a virtual machine with screenshots for every step in the process. Install Windows 7 Beta onto a Virtual Machine
	Click to view Braintrove article: Convert Between Time and Decimal Written by Gregory Scot Collins Friday, 31 October 2008, 7:36 AM Products: Excel and Office While not readily apparent, conversion between time and decimal in Excel is really quite simple. Convert Between Time and Decimal
	Click to view Braintrove article: Configure Lab Color Mode Defaults for Braintrove Articles Written by Gregory Scot Collins Wednesday, 30 April 2008, 10:36 PM Product: Photoshop Make the appropriate changes in a couple of dialog boxes in order to complete the tasks of Braintrove articles involving the Photohshop Lab Color mode. Configure Lab Color Mode Defaults for Braintrove Articles
	Click to view Braintrove article: Permanently Change the Default Styles for New Word Documents Written by Gregory Scot Collins Wednesday, 18 February 2009, 4:54 PM Products: Office and Word Using this surprisingly simple technique, you can quickly change the way that all newly created Microsoft Word documents look. Permanently Change the Default Styles for New Word Documents
	Click to view Braintrove article: Use the Eyedropper Tool to Pick a Color From Anywhere Written by Gregory Scot Collins Tuesday, 4 March 2008, 8:59 AM Product: Photoshop While not very discoverable, Photoshop already has the ability to pick a color from anywhere on your screen using the Eyedropper tool. Use the Eyedropper Tool to Pick a Color From Anywhere

		Microsoft MVP

This article has been viewed 231 times.

Sum Repeating Time Values

Written by Gregory Scot Collins

Tuesday, 14 April 2009, 2:31 PM

This article has been tested to work with the following products and versions. No guarantee of compatibility, with or without modification, is offered for products or versions other than those listed.

InfoPath 2007 (Microsoft)
Office 2007 (Microsoft)

IN THIS ARTICLE:

If you have a need to add up time values in an InfoPath repeating table or section, you can use the eval() function to accomplish your task.

The eval() function

eval() takes two arguments and returns a node-set containing the results of the expression in the second argument (which must exist in quotes) as applied to the node-set in the first argument.

Convert time to seconds

InfoPath stores time in the XML format of HH:MM:SS (hours, colon-separator, minutes, colon-separator, seconds). In this example, we will convert each time value to seconds and get the sum. Once we've obtained the sum in seconds, we can then display the number of seconds, or divide out into minutes or whatever.

To convert a time value into seconds, we must individually select the hours, minutes and seconds. Hours are converted to seconds when multiplied by 3600 and minutes are converted to seconds when multiplied by 60.

To get each portion of an XML time value, we will use the substring() function. substring() is 1-based, meaning the first character is found at position 1.

Perform the sum

With a DOM structure of my:myFields/my:Table/my:Row/my:TimeField, you can use the expression shown in Listing 1 in an Expression Box or a default value formula to get the sum of time in seconds:

sum(xdMath:Eval(my:Table/my:Row/my:TimeField[. != ''], "(substring(., 1, 2) * 3600 + substring(., 4, 2) * 60 + substring(., 7, 2))"))

Listing 1. Obtaining a sum in seconds from a repeating list time values.

We included the filter [. != ''] to ensure that only fields with values are included in the evaluation. This prevents the expression from resulting in the 1.#QNAN error. However, you will still get this error if you have invalid or non-time values in your list.

Convert to minutes or hours

If you prefer to display the sum minutes, append the expression in Listing 1 with div 60, or div 3600 if you prefer hours.

Copyright ©2009 Braintrove. All rights reserved. This material may not be copied, published, broadcast, rewritten or redistributed. You may, however, use the techniques, along with any associated code and files in your development. This material is provided "AS IS" without warranty of any kind. You accept full responsibility and liability for any and all results associated with use of this material.

		Bookmark this Article
	Stumble It!
	Digg It!
	del.icio.us

		List of Figures
	Listing 1 - Obtaining a sum in seconds from a repeating list time values.

		Article Tags
	Default Value Formulas eval() Expression Boxes Hours InfoPath Minutes Seconds substring() sum() Time

		Great Deals
	TigerDirect Exclusive Deals, Limited Time Offers, Act Now And Save!
	Find all current special offers on Adobe products.

Copyright © 2006-2010 Braintrove. All rights reserved. Braintrove, braintrove.com, and the Braintrove logo are trademarks of Gregory Scot Collins in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners. Any rights not expressly granted herein are reserved.