General

Re: Format text box for time that requires _ _ _ : _ _ format to allow for hours calculated to greater then 24 ----- Please reply quickly!!!

tiatia — Sat, 25 Jan 2014 16:41:44 GMT

Thank you again Jimmy. This leads me to another question - can I set an info path field to add the hours and populate a text field in this format?

Re: Format text box for time that requires _ _ _ : _ _ format to allow for hours calculated to greater then 24 ----- Please reply quickly!!!

tiatia — Tue, 14 Jan 2014 04:13:47 GMT

Exactly what I needed; thank you!

Re: Format text box for time that requires _ _ _ : _ _ format to allow for hours calculated to greater then 24 ----- Please reply quickly!!!

Jimmy — Fri, 10 Jan 2014 18:30:44 GMT

So you want to have a field that requires the user to enter a value of the format AAA:BB where AAA is any whole number and BB is a number between 00 and 59 inclusive. Did I understand that right?

If so, you can place a validation rule on the field to check whether the field does not match the pattern:

\d+:[0-5]\d

This will require making the data type an ordinary string data type, as the Time datatype requires the hours to be between 0 and 23.

Format text box for time that requires _ _ _ : _ _ format to allow for hours calculated to greater then 24 ----- Please reply quickly!!!

tiatia — Thu, 09 Jan 2014 20:58:00 GMT

I hope you can help me. I have an info path web part form that is connected to an excel web part. I have 3 fields in the IP form that routes to excel for a calculation - # of employees reported, empSTHours, empOTHours. Upon button click on the form, the data populates in an excel spreadsheet with calculated combined straight time hours and combined over time hours. For example: 13 employees worked 8:00 straight time hours and 4:23 overtime. The total equals 104 straight time hours, 56:59 overtime hours and a total of 160:59. I want the user to enter the totals back in the info path form after calculations have been done and I want to require it to be in the same format as the fellow person in this post, i.e. 00:00. So, I followed all of the steps attached here and my form requires that the user enter the data as time up to 23:59. I need to format the cells, however, to allow for any time over 24 hours. So, for example, I need the user to be able to enter 104:00 in the combinedSTHours field, and 56:59 in combinedOTHours and 160:59 in totalHours. Can you help me?

Thank you!