Need help with cell formatting
 

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?

Need help with cell formatting
 

Start in A1
End in B1
Format C1 to General or Number, then enter
=MOD(B1-A1,1)*24

The Mod is for times spanning midnight.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bwpark" wrote in message
...
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?

Need help with cell formatting
 

Assuming that the times are real XL times then to turn tham into decimal
numbers multiply the total by 24

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"bwpark" wrote in message
...
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?