I have made a form in which there is a table of 30 rows  with INTIME and OUTTIME(2 sets in single row)  with a cell in which it calculates the difference of time between INTIME and OUTTIME.....everything is working fine except for whenever there is  08 or 09 in minutes  then either there is no calcu...

Hours less than 1 issue solved......... one last issue is that i want user to user only data in HH:MM format that too between 00:00 to 23:59 (24hrs time)...... when i set the cell to Time form the calculations don't work.... plz guide

The script has one issue .... when i input time which is less than an hour then it gives 24 hours .. for example : intime : 06:25; outtime = 06:40 then result is 24:15 instead of 00:15

ok.... nice... the script is working exactly as i desired... now few things more.. i want to restrict user so that they cannot enter anything expect time format HH:MM also should not be able to enter greater than 00:00 = 12:00 am (24hrs time format)  ..also want to add all results in the total cell

ok.. how to add all the result time (30 of them)

variable script you gave is of no use as i have 30 rows .. i had to copy and paste the whole script in each of the outtime cell....

If you can share your sample working file

do i need to change "result.rawValue" to my result field name, if that is so then how to use this variable with other rows.....

not working ....... i have whole table with 30 rows with each row having 2 sets of time... ..

I am trying to make a form in a tabular form in which there are two sets of time in a single row 1st setCell4 : InTime     Cell5 : OutTime2nd set Cell6: InTimeCell7:OutTime  I have the script  and it calculates the difference between intime and outime and then add both set  but  it adds only after a...