Entering durations in Infopath for Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paulinlondon - 10 Nov 2006 15:06 GMT

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!

Reply to this Message

S.Y.M. Wong-A-Ton - 12 Nov 2006 02:49 GMT

Have you already looked into using the concat() function in a formula?
---
S.Y.M. Wong-A-Ton

> 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!

Reply to this Message

paulinlondon - 13 Nov 2006 10:16 GMT

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

Thank you

Paul

> Have you already looked into using the concat() function in a formula?
> ---
[quoted text clipped - 6 lines]
> > format them into durations, such as 01:23:42 (1 hour, 23 minutes, 42
> > seconds). Any ideas anyone? Thanks in advance for any replies!

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Nov 2006 23:52 GMT

The concat() function can be used in a formula to concatenate strings. Take a
look at this article:
http://enterprise-solutions.swits.net/infopath2003/article.php?t=auto-format-tim
e-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.
---
S.Y.M. Wong-A-Ton

> I'm rather new to Infopath. What is the concat () funtion and how would I do
> it?!
[quoted text clipped - 13 lines]
> > > format them into durations, such as 01:23:42 (1 hour, 23 minutes, 42
> > > seconds). Any ideas anyone? Thanks in advance for any replies!

Reply to this Message