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!