i am writing a time and attendance application. i have some datetime fields that contain the timein and timeout. I would like to calculate the hours worked between these two times and round the hours to the 1/4 hour.
id | name | date | timein1 | timeout1 | timein2 | timeout2
or with data ..
1 | frank | 03/26/2006 | 8:00 AM | 12:00 PM | 1:00 PM | 5:15 PM
how can i cfset a variable for the correct total hours worked that day. (for this record, the result for total hours worked should be .. 8.25)