I'm creating a timesheet for our payroll system. I have a row where
employees enter the times they punch in and out each day then at the end of
the row there is a function to automatically total the number of hours
worked. My problem is that the punch-in and punch-out entries are in an
(h:mm) format and I need the cell containing the total to be in a decimal
format. How do I format it so that working 8 hours and fifteen minutes shows
up in the total column as 8.25 rather than 8.15?