Adding columns of times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to add increments of time (in the h:mm format, for example 3:15),
to come up with the total hours and minutes in part of a column, in Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats and
neither works properly. I've tried adjusting the format of the cell with the
formula in it. Still not working. Can anyone help? Thanks.
 
Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor
 
Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and then
choose Time and then the 13:30 format? Because that didn't seem to work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that and it's
not working but perhaps I'm not doing it right. Could you spell out the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the
response!

Trevor Shuttleworth said:
Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



hadleigh said:
I'm trying to add increments of time (in the h:mm format, for example
3:15),
to come up with the total hours and minutes in part of a column, in Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24 formats
and
neither works properly. I've tried adjusting the format of the cell with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
 
Use Format | Cells... | Custom | Type: [hh]:mm

Regards

Trevor


hadleigh said:
Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and then
choose Time and then the 13:30 format? Because that didn't seem to work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that and
it's
not working but perhaps I'm not doing it right. Could you spell out the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the
response!

Trevor Shuttleworth said:
Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



hadleigh said:
I'm trying to add increments of time (in the h:mm format, for example
3:15),
to come up with the total hours and minutes in part of a column, in
Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24
formats
and
neither works properly. I've tried adjusting the format of the cell
with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Trevor,

Thanks very much for the response. This is working fine now as long as the
total hours don't equal more than 24. The sum isn't right if the total is
more than 24 hours (even when I add *24 to the formula) but at least it's
working right in the other cases.

Regards,
Hadleigh


Trevor Shuttleworth said:
Use Format | Cells... | Custom | Type: [hh]:mm

Regards

Trevor


hadleigh said:
Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and then
choose Time and then the 13:30 format? Because that didn't seem to work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that and
it's
not working but perhaps I'm not doing it right. Could you spell out the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the
response!

Trevor Shuttleworth said:
Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



I'm trying to add increments of time (in the h:mm format, for example
3:15),
to come up with the total hours and minutes in part of a column, in
Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24
formats
and
neither works properly. I've tried adjusting the format of the cell
with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
The point of the square brackets ([]) around the hh thus[hh] is
to cater for more than 24 hours. You should be able to accumulate hundreds
of hours.

12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00
24:00
25:00

259:00


all formatted as [hh]:mm

Regards

Trevor


hadleigh said:
Trevor,

Thanks very much for the response. This is working fine now as long as
the
total hours don't equal more than 24. The sum isn't right if the total is
more than 24 hours (even when I add *24 to the formula) but at least it's
working right in the other cases.

Regards,
Hadleigh


Trevor Shuttleworth said:
Use Format | Cells... | Custom | Type: [hh]:mm

Regards

Trevor


hadleigh said:
Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and
then
choose Time and then the 13:30 format? Because that didn't seem to
work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that
and
it's
not working but perhaps I'm not doing it right. Could you spell out
the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the
response!

:

Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



I'm trying to add increments of time (in the h:mm format, for
example
3:15),
to come up with the total hours and minutes in part of a column, in
Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24
formats
and
neither works properly. I've tried adjusting the format of the cell
with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
NOW I get it. I thought I had to select [hh]:mm which wasn't an option under
the Type column when I was formatting the cell. So I was using the closest
thing, which was h:mm. Now I realize I can type in my own entry, so I typed
in [hh]:mm and it worked like a charm. THANK YOU SO MUCH!!

Trevor Shuttleworth said:
The point of the square brackets ([]) around the hh thus[hh] is
to cater for more than 24 hours. You should be able to accumulate hundreds
of hours.

12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00
24:00
25:00

259:00


all formatted as [hh]:mm

Regards

Trevor


hadleigh said:
Trevor,

Thanks very much for the response. This is working fine now as long as
the
total hours don't equal more than 24. The sum isn't right if the total is
more than 24 hours (even when I add *24 to the formula) but at least it's
working right in the other cases.

Regards,
Hadleigh


Trevor Shuttleworth said:
Use Format | Cells... | Custom | Type: [hh]:mm

Regards

Trevor


Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command, and
then
choose Time and then the 13:30 format? Because that didn't seem to
work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that
and
it's
not working but perhaps I'm not doing it right. Could you spell out
the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for the
response!

:

Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



I'm trying to add increments of time (in the h:mm format, for
example
3:15),
to come up with the total hours and minutes in part of a column, in
Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24
formats
and
neither works properly. I've tried adjusting the format of the cell
with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
Click to expand...
 
You are very welcome.

Regards

Trevor


hadleigh said:
NOW I get it. I thought I had to select [hh]:mm which wasn't an option
under
the Type column when I was formatting the cell. So I was using the
closest
thing, which was h:mm. Now I realize I can type in my own entry, so I
typed
in [hh]:mm and it worked like a charm. THANK YOU SO MUCH!!

Trevor Shuttleworth said:
The point of the square brackets ([]) around the hh thus[hh]
is
to cater for more than 24 hours. You should be able to accumulate
hundreds
of hours.

12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00
24:00
25:00

259:00


all formatted as [hh]:mm

Regards

Trevor


hadleigh said:
Trevor,

Thanks very much for the response. This is working fine now as long as
the
total hours don't equal more than 24. The sum isn't right if the total
is
more than 24 hours (even when I add *24 to the formula) but at least
it's
working right in the other cases.

Regards,
Hadleigh


:

Use Format | Cells... | Custom | Type: [hh]:mm

Regards

Trevor


Sorry to be dense, but I'm something of an Excel novice and I don't
understand this. Do you mean to go into the Format/Cell command,
and
then
choose Time and then the 13:30 format? Because that didn't seem to
work.
Or, do I add [hh]:mm into the formula for the cell? I've tried that
and
it's
not working but perhaps I'm not doing it right. Could you spell out
the
right formula? Is it =SUM(cell:cell)*24[hh]:mm? Many thanks for
the
response!

:

Format the result cell as:

[hh]:mm

03:15
12:40
07:35
06:10

29:40


Regards

Trevor



I'm trying to add increments of time (in the h:mm format, for
example
3:15),
to come up with the total hours and minutes in part of a column,
in
Excel
2002. I've tried the =SUM(cell:cell) and the =SUM(cell:cell)*24
formats
and
neither works properly. I've tried adjusting the format of the
cell
with
the
formula in it. Still not working. Can anyone help? Thanks.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SUM function to count hours BUT ignore Letters? 6
summing cells of Time 1
PROPER function 2
Excel formula for adding up sub-totals in time format 2
time adding in excell 6
Calculating Resolution Rates 2
Adding Days and Hours 8
Calculating Time 5

Back
Top