Adding time

[Lorrie]

I'm going crazy. I'm trying to add up a column of time.
Employee enters time in and out for a two week period.
The total number of hours appear in column I for each
day, but then I need to add up the total number of hours
for the period.

Example:
Total hours
7:45
0:15
0:00
4:00
8:00
7:30
9:30
0:00
0:00
8:30
TOTAL????
Any suggestions? - do I have to convert the 7:45 to 7.75
some way and if so how?

Thank you, in advance, for your help.

Lorrie

 

[Peo Sjoblom]

Lorrie,

format resukt as [h]:mm to get the hours to roll over after 24:00, if you
want the decimal hour multply with 24

=SUM(A2:A11)*24

format as general or else it's likely you get a time format
If you want to get an amount using a payrate

=SUM(A2:A11)*24*payrate

 

[Guest]

Thank you for trying to help. I entered the formula as
you suggested (=SUM(I9:I24)*24 - with the figures that
are shown below) and formatted the cell to general and
still the answer is 0:00. What am I doing wrong?

-----Original Message-----
Lorrie,

format resukt as [h]:mm to get the hours to roll over after 24:00, if you
want the decimal hour multply with 24

=SUM(A2:A11)*24

format as general or else it's likely you get a time format
If you want to get an amount using a payrate

=SUM(A2:A11)*24*payrate

--

Regards,

Peo Sjoblom

I'm going crazy. I'm trying to add up a column of time.
Employee enters time in and out for a two week period.
The total number of hours appear in column I for each
day, but then I need to add up the total number of hours
for the period.

Example:
Total hours
7:45
0:15
0:00
4:00
8:00
7:30
9:30
0:00
0:00
8:30
TOTAL????
Any suggestions? - do I have to convert the 7:45 to 7.75
some way and if so how?

Thank you, in advance, for your help.

Lorrie

.

 

[Guest]

Thank you for trying to help. I entered the formula as
you suggested (=SUM(I9:I24)*24 - with the figures that
are shown below) and formatted the cell to general and
still the answer is 0:00. What am I doing wrong?

-----Original Message-----
Lorrie,

format resukt as [h]:mm to get the hours to roll over after 24:00, if you
want the decimal hour multply with 24

=SUM(A2:A11)*24

format as general or else it's likely you get a time format
If you want to get an amount using a payrate

=SUM(A2:A11)*24*payrate

--

Regards,

Peo Sjoblom

I'm going crazy. I'm trying to add up a column of time.
Employee enters time in and out for a two week period.
The total number of hours appear in column I for each
day, but then I need to add up the total number of hours
for the period.

Example:
Total hours
7:45
0:15
0:00
4:00
8:00
7:30
9:30
0:00
0:00
8:30
TOTAL????
Any suggestions? - do I have to convert the 7:45 to 7.75
some way and if so how?

Thank you, in advance, for your help.

Lorrie

.

 

[Peo Sjoblom]

Most likely you formatted to general before you applied the *24,
first use the formula, then apply the formatting..

--

Regards,

Peo Sjoblom

Thank you for trying to help. I entered the formula as
you suggested (=SUM(I9:I24)*24 - with the figures that
are shown below) and formatted the cell to general and
still the answer is 0:00. What am I doing wrong?

-----Original Message-----
Lorrie,

format resukt as [h]:mm to get the hours to roll over after 24:00, if you
want the decimal hour multply with 24

=SUM(A2:A11)*24

format as general or else it's likely you get a time format
If you want to get an amount using a payrate

=SUM(A2:A11)*24*payrate

--

Regards,

Peo Sjoblom

I'm going crazy. I'm trying to add up a column of time.
Employee enters time in and out for a two week period.
The total number of hours appear in column I for each
day, but then I need to add up the total number of hours
for the period.

Example:
Total hours
7:45
0:15
0:00
4:00
8:00
7:30
9:30
0:00
0:00
8:30
TOTAL????
Any suggestions? - do I have to convert the 7:45 to 7.75
some way and if so how?

Thank you, in advance, for your help.

Lorrie

.