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.

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.

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.

You didn't mention that part about hours as well.

Try this array formula

=SUM(INT(A2:A20))+SUM(MOD(A2:A20,1))*2.5

--

HTH

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


"Short on time and money."
wrote in message ...
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.

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.

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.

Hi

Then don't be so sparse with useful info! P.e. description of your table
will be a great help - where are time values stored (at least column), how
are hours for different days identified/positioned (date column, or every
day in different column), etc.


Arvi Laanemets


"Short on time and money."
wrote in message ...
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.

Hi

Replace semicolons in formula with commas (sorry, I did forget to do so
before sending the answer)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"Short on time and money."
wrote in message ...
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.