Time Sheet turmoil.

[Guest]

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.

 

[Bob Phillips]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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

 

[Arvi Laanemets]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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.

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
(e-mail address removed)> 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.

 

[Bob Phillips]

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)

 

[Arvi Laanemets]

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

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.

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
(e-mail address removed)> 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.

 

[Arvi Laanemets]

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<at>tarkon.ee )

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.

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
(e-mail address removed)> 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.