Brian Barker wrote:
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
Beautiful.
It was the time-as-fraction-of-a-day that threw me off.
multiplying by 24 and all is well
--
Bill Drescher
william {at} TechServSys {dot} com
