Your answer would multiply the hours as well as the partial hours.

"Bob Phillips" wrote:

Is it not just

=SUM(A2:A20)*2.5
--

HTH

RP
(remove nothere from the email address if mailing direct)


"Short on time and money." <Short on time and
wrote in message
...
We log our time as h.1, h.2, h.3. Each .1 is equal to .25 or 15 minutes.
I
would like to have the time sheet auto calculate the hours worked each day
and put that total in the total column. I've tried to format the cell as
0
?/4 but it still sees the number after the decimal as a tenth.