surely it cannot be that difficult...

[Bob Holdford]

......can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57


All I need to do is add the hours and minutes up!!! The answer is looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob

 

[Dave Peterson]

=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss

 

[Bob Holdford]

Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the times
are.


My head really hurts now :-(

Cheers Bob

=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob

 

[Dave Peterson]

My guess is that the cells that look like times are really text (not numbers).

Try selectinging an empty cell
edit|copy
select the range with the times
edit|paste special|check add and values
(maybe re-apply a nice time format to that range)

Now look at the cell with =sum() in it.

Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the times
are.

My head really hurts now :-(

Cheers Bob

=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob

 

[Bob Holdford]

Nope!! Well, I am thick, but could not get that to work.

Format Cells, suggests 'Custom' & 'hh:mm'.

Possibly be much easier if I stopped thinking

My guess is that the cells that look like times are really text (not
numbers).

Try selectinging an empty cell
edit|copy
select the range with the times
edit|paste special|check add and values
(maybe re-apply a nice time format to that range)

Now look at the cell with =sum() in it.

Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the
times
are.

My head really hurts now :-(

Cheers Bob

=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss



Bob Holdford wrote:

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob

 

[Dave Peterson]

If all you did was change the format, then that isn't enough to change the
values in the cell.

You may want to show a few examples of what's in that range (formulas and
values) and what the formula evaluated to.

Without more information, I'm out of guesses.

Nope!! Well, I am thick, but could not get that to work.

Format Cells, suggests 'Custom' & 'hh:mm'.

Possibly be much easier if I stopped thinking

My guess is that the cells that look like times are really text (not
numbers).

Try selectinging an empty cell
edit|copy
select the range with the times
edit|paste special|check add and values
(maybe re-apply a nice time format to that range)

Now look at the cell with =sum() in it.

Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the
times
are.

My head really hurts now :-(

Cheers Bob
=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss



Bob Holdford wrote:

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob

 

[Dave Peterson]

You may want to show a few examples of what's in that range (formulas and
values) and what the =SUM() formula evaluated to.

If all you did was change the format, then that isn't enough to change the
values in the cell.

You may want to show a few examples of what's in that range (formulas and
values) and what the formula evaluated to.

Without more information, I'm out of guesses.

Nope!! Well, I am thick, but could not get that to work.

Format Cells, suggests 'Custom' & 'hh:mm'.

Possibly be much easier if I stopped thinking

My guess is that the cells that look like times are really text (not
numbers).

Try selectinging an empty cell
edit|copy
select the range with the times
edit|paste special|check add and values
(maybe re-apply a nice time format to that range)

Now look at the cell with =sum() in it.

Bob Holdford wrote:

Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the
times
are.

My head really hurts now :-(

Cheers Bob
=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss



Bob Holdford wrote:

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please

Best regards

Bob