We have a timesheet form that has 4 time fields: Start Time, End Time, Actual Time and Billable Time.
Our Start Time, End Time and Actual Time buttons and field calculations work just fine, but we want the 4th field to calculate the billable time by rounding UP to the quarter-hour.
Start Time - 9:00am
End Time - 11:20am
Actual Time - 2:20
Billable Time - 2:30 (or 2h30min)
I'm new to Infopath and not sure how we would accomplish this. What type of code would I need and can I even use code on that Billable Time field to accomplish this?
Thanks for any help you can give me!
View Complete Post