InfoPath Dev

Hello, I have two questions. 1 - I have created a form wherein the time is in format of 00:35:15 how can i convert it in seconds. 2 - Is there is any possiblity to disable the Ctrl+Z function to avoid data furging. Thanks for your support. regards, Upender Singh

Hello Hillary, Actually I am not able to get the correct function and when I try to divide seconds I might getting validation error. Please help me the function to convert the time to seconds and how to rectify the validation error. Is it possible to disable undo and cntl+z function from info path. Regards, Upender Singh

Hello, I have a filed i.e. Total Shift hours and I want to get total seconds of total shift hour to new feild i.e. shift adherence and divide it by 09:30:00 i.e. 34200 seconds *100 to get % value. For example: My total shift hour is 08:20:15 hence seconds should be 08*3600 = 28800 20*60 = 1200 15 = 15 total =  28800 + 1200 + 15 = ...

Hello Hilary, Thank you for your support. I have  checked the form and understand the calculation. That's really helpful..I m confident now as able to complete this form very soon. I appreciate your knowledge and kind support. Regards, Upender Singh

Hello David, I am new to infopath and coding. I designed the form on which I want to disable undo so no changes can be made. I have tried the above code but it not blocked the undo or redo once you tab out. Could you please help as how to block the undo once the feild is tab out. Thanks for your support in advance. Regards, Upender ...

Hello Hilary, Thank you for your support. I m new to infopath and acquiring knowledge from web and learning it got lot of functions but frankly speaking bit hard to understand the function part for calcuation for time. I done calculation for numeric figure it work for me on other form but time function is really tough to understand. Thank you ...

Hello Hilary, Thank you for your post. Yes you are correct all my feild are date and time. I tried the function concat(today(), "T01:00:00") and it works as giving the duration of 01 hour. I have gone throug the msdn blog but I am sorry as not able to understand it as it is calcuating the time from dailytimeminutes ...

Hello Hilary, Thank you for your support as it resolved my concern but still get stuck with other function. 1)  I have tried to get total of 01st break total + 02nd Break total + 03rd Break total however no sucess. Could you please explain how to sum up the total break function. 2) Is there any function or rule by which we can ...

Hello Hilary, As you have advsied we need to write a code to get the total shift hours hence I have added a current time feild on form which will reflect once shift status is selected. Once shift status selected it will reflect the current time on current time feild and total shift hour feild will get it value from current time - logged out date ...

Hello Hilary, Thank you for your support provided to get the query resolved. Regards, Upender Singh