B
bwpark
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?
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?