Forums

Timesheet

papin0 13 Jun, 2013
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
GreyHead 17 Jun, 2013
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
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount
hostinger