Entering durations in Infopath for Calculations

[paulinlondon]

Hi, pleease help! Been tasked with creating a form whereby I need to enter
durations in hours, minutes and seconds and use the information to do some
further calculations in Infopath automatically, ie, totals, averages, etc!
I've managed to do all that with 'normal' numbers, but I've not been able to
format them into durations, such as 01:23:42 (1 hour, 23 minutes, 42
seconds). Any ideas anyone? Thanks in advance for any replies!

 

[S.Y.M. Wong-A-Ton]

Have you already looked into using the concat() function in a formula?

 

[paulinlondon]

I'm rather new to Infopath. What is the concat () funtion and how would I do
it?!

Thank you

Paul

 

[S.Y.M. Wong-A-Ton]

The concat() function can be used in a formula to concatenate strings. Take a
look at this article:
http://enterprise-solutions.swits.n...=auto-format-time-on-lostfocus&c=infopath2003

To create a string like "01:23:42" you could use
concat("01",":","23",":","42") in a formula. Search the InfoPath Help to get
more information on what the concat() function and other functions can do for
you.