InfoPath Dev

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 = 30015

total mandate shift hour is 09:30:00 hence total seconds is 34200.

hence shift adherence will be 30015 / 34200 * 100 to get percentage figure.

Thanks for your support.

Regards,

Upender Singh

 

So, I'm sorry, I am unclear on what is going wrong when you try this?

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