At 10:49 08/06/2008 -0400, Bill Drescher 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.
This may be simpler than you think. If you enter the values by just
typing, e.g. 1:06, then they will be stored and formatted as
times. Although what you see is "1:06", what is actually stored in
the cell is a numeric value in days. You can see this by
right-clicking the cell and selecting Default Formatting. You will
see "0.05" and, if you increase the number of fractional places
displayed, 0.04583333333. Your one hour and six minutes is that
fraction of a day.
If you need the value in hours instead of days, you merely need, of
course, to convert it by multiplying by 24. Provided the result cell
is formatted as a number, you should see your required 1.1. If - as
I guess - you may not need the value actually displayed but merely to
use it in a calculation somewhere, you can just include the cell
value along with the conversion factor there, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
