InfoPath Dev

I need help with formula or code to convert time entered in one field to decimal time in another field.  For example, 2:33 would get converted to 2.55.  Any help would be appreciated, thanks.

try this code:

public void CTRL2_5_Clicked(object sender, ClickedEventArgs e)
{
 XPathNavigator root = MainDataSource.CreateNavigator();
 string Time = root.SelectSingleNode("/my:myFields/my:field1", NamespaceManager).Value;
 string[] Temp = Time.Split(':');
 root.SelectSingleNode("/my:myFields/my:field2", NamespaceManager).SetValue((int.Parse(Temp[0])+(double.Parse(Temp[1])/60)).ToString());
}

HTH

Or you can just use this formula:

concat(substring-before(field, ":"), ".", 100 * substring-after(field, ":") div 60)

round(100 * substring-before(field, ":") + 100 * (substring-after(field, ":") div 60)) div 100

 1:59 gets converted to 1.98.33333333333333

12:11 gets converted to 12.18.33333333333332 

try using the round() function in the formula:

round(100*substring-after(field, ":") div 60)

or use ToString("#.##") in the C# code:

(int.Parse(Temp[0]) + (double.Parse(Temp[1]) / 60)).ToString("#.##")

As you can tell working with formulas is not my strong suit...  I tried the following formula and this is the error message I get:

Formula: 

concat(substring-before(NCRHours, ":"), ".", round(100 * substring-after(NCRHours, ":") / 60)

Error Message:

Expected value type: ,

Actual value: end-of-string
concat(substring-before(NCRHours, ":"), ".", round(100 * substring-after(NCRHours, ":") div 60)<--

 Looks like you're missing an end-parenthesis.

It works!!!  You have no idea how appreciated this is - thanks a billion times!!!!!

I love Notepad2 for things like this (note, link is to the .zip file for the download) -- it has parenthetical matching -- highlights your parentheses when you select them, so that you can see the pairs easily.

Hey! Have the same problem, i want to convert the time into decimal but i cannot get this code to work. I don't understand what i am doing wrong.

Let's say i have two fields field1 is showing the normal time 2:33 how do i get field2 to convert the time to 2.55?
I tried the code Jimmy was mentioning but i can not get it to work.

Any help will be appreciated!

Sorry about reopening a fairly old thread. I'm having an issue with converting times involving 5 mintue intervals. For instance, when I convert 1:05 (h:mm), it is computed as 1.8. The code formula I'm using is: concat(substring-before(IncomingTime, ":"), ".", round(100 * substring-after(IncomingTime, ":") / 60))

It appears that formula is treating 05 as 50, hence the .8 of an hour. Does anyone have any suggestions on how to treat it as 5 minutes in lieu of 50?

Actually, it's doing this:

concat(1, ".", round(100 * 05 / 60))

concat(1, ".", round(8.33333))

concat(1, ".", 8)

1.8

And I must blame my own naïveté for posting that faulty formula 3 years ago.  

I'd suggest this formula:

round(100 * substring-before(IncomingTime, ":") + 100 * (substring-after(IncomingTime, ":") div 60)) div 100

And I'll correct my post above.

Thanks for the very quick response. In working with the formula, I needed modify your suggestion to get the rounding and decimal placement correct in the final value.

(100 * substring-before(IncomingTime, ":") + (substring-after(IncomingTime, ":") / 60) * 100) / 100

But things are working swimmingly. Thanks Jimmy.

 I am trying to do this in InfoPath 2013 and it is not working I have a field with a time OperationalTime and it ='s 12:30  in the conversion field I have it set to double and the formula is : (100 * substring-before(OperationalTime, ":") + (substring-after(OperationalTime, ":") / 60) * 100) / 100  All I am getting is NaN in the field

I also tried concat(substring-before(OperationalTime, ":"), ".", round(100 * (substring-after(OperationalTime, ":")) / 60)) and I get 12.NaN 

 When I just run substring-after(OperationalTime, ":") it returns 30:00 instead of 30