On 08/06/2008 15:49, bill wrote:
I collect timesheet information as hh:mm, but to computer pay I need
to convert it to decimal hours,
e.g: 1:06 -> 1.1
I am sure there is a way to do this, but I just can't figure it.
Assume the times are in column A and you want the decimal values in B.
Makes sure column B is formatted as numeric and with the number of
decimal places you want. In B1, enter the formula "=hour(a1) +
minute(a1)/60". For 1:06 that gives 1.10 to 2 decimal places. Now drag
the formula down column B so that it auto-adjusts for rows 2, 3, ...
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
