Adding time

  • Thread starter Thread starter Lorrie
  • Start date Start date
L

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
 
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
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top