That may be a good idea, but I can't get it to work. I guess I'm not Excel
savy enough to figure it out.

"Arvi Laanemets" wrote:

Hi

An array formula (entered with Ctrl+Shift+Enter) like (entries not out of
range A1:A100, the cell with formula formatted as Custom "[h]:mm")
=SUM(TIME(INT(A1:A100);MOD(A1:A100;1)*150;0))

But you avoid a lot of trouble simply using normal time format, like "h.mm".



Arvi Laanemets



"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.