Forums

we are looking to create a timesheet form to do:
I want to calculate time like this on a form:


Time In = 3:00 pm time Out = 3:13 pm = 15 minutes = 1 Unit

Time In = 3:00 pm time Out = 4:00 pm = 60 minutes = 4 Units

Time In = 3:00 pm time Out = 3:20 pm = 15 minutes = 1 Unit

-------------------------------------------------------------------

Total Minutes = 90 Minutes = 6 Units (1 Unit = 15 minutes)

The actual time spent must be totaled and rounded to the nearest unit. If the minutes total ends in a 7 or less, round down to the nearest 15-minute increment. If the minutes total ends in 8 or more, round up to the nearest 15-minute increment. For example, 37 minutes is billed as two units of service; 38 minutes is billed as three units of services.




Any Help is appreciated

we need multiple rows

Hi papin0,

You can do this in ChronoForms. But it will take some custom PHP and JavaScript and MySQL to get it working smoothly. If you are not reasonably skilled in these you may need to find a web developer to help.

Bob