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.
If you want a formula, in psudocode it is hours + minutes/60 and if you
need more, +seconds/3600.
Time is already stored in a cell as a raw decimal number. It looks like
NN:MM:SS because of the cell formatting. Knowing this can be useful to
perform math on a time.
If you need examples of doing this, return to the mail list with a
specific question.
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
