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