Code

Re: Convert time to decimal time

recono1 — Thu, 09 Jan 2014 16:30:05 GMT

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

Re: Convert time to decimal time

Jimmy — Wed, 12 Dec 2012 18:52:20 GMT

Good catch and thank you for pointing it out. I'll modify my formula accordingly.

Re: Convert time to decimal time

workin'stiff — Wed, 12 Dec 2012 18:50:05 GMT

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.

Re: Convert time to decimal time

Jimmy — Wed, 12 Dec 2012 17:16:04 GMT

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.

Re: Convert time to decimal time

workin'stiff — Wed, 12 Dec 2012 16:48:03 GMT

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?

Re: Convert time to decimal time

rjanssen — Thu, 18 Feb 2010 19:51:12 GMT

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!

Re: Convert time to decimal time

Hilary Stoupa — Wed, 20 Jan 2010 21:21:25 GMT

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.

Re: Convert time to decimal time

samonenate — Wed, 20 Jan 2010 18:03:54 GMT

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

Re: Convert time to decimal time

Jimmy — Wed, 20 Jan 2010 17:34:21 GMT

Looks like you're missing an end-parenthesis.

Re: Convert time to decimal time

samonenate — Wed, 20 Jan 2010 17:14:48 GMT

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

Re: Convert time to decimal time

ricomarcelo — Mon, 18 Jan 2010 22:27:23 GMT

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("#.##")

Re: Convert time to decimal time

samonenate — Mon, 18 Jan 2010 19:59:59 GMT

The formula is working, but for some calculations it is adding 2 decimal points for calculations that go to infinity. I tried changing the field with the formula from Text to Decimal, but I get validation errors. Here is an example of what is occurring:

1:59 gets converted to 1.98.33333333333333

12:11 gets converted to 12.18.33333333333332

Re: Convert time to decimal time

Jimmy — Fri, 15 Jan 2010 03:34:44 GMT

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

Re: Convert time to decimal time

ricomarcelo — Thu, 14 Jan 2010 22:08:27 GMT

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

Convert time to decimal time

samonenate — Thu, 14 Jan 2010 20:00:15 GMT

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.