Hi All
I am designing a timesheet system. In this if you see the attached file there are diff boxes for hours and minutes. Minutes are 15 min block so the user can only type 0,15,30,45 in mm boxes. and in hh boxes they can type whole numbers from 0 to 10. I have put all the validations in my system.Now the problem is I want the total like 7.15 .so that when the user press enter after typing values in boxes then it should display in the total box 7.15 means they have worked 7 hours and 15 minutes on Monday.
Suppose I enter some values in these hh and mm boxes and press enter and it gives me 5.135 answer in total textbox. So the answer should be 7.15. Can anyone please give me the code to do this calculation. Please find attached a sample file.
I am designing a timesheet system. In this if you see the attached file there are diff boxes for hours and minutes. Minutes are 15 min block so the user can only type 0,15,30,45 in mm boxes. and in hh boxes they can type whole numbers from 0 to 10. I have put all the validations in my system.Now the problem is I want the total like 7.15 .so that when the user press enter after typing values in boxes then it should display in the total box 7.15 means they have worked 7 hours and 15 minutes on Monday.
Suppose I enter some values in these hh and mm boxes and press enter and it gives me 5.135 answer in total textbox. So the answer should be 7.15. Can anyone please give me the code to do this calculation. Please find attached a sample file.