surely it cannot be that difficult...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Holdford - 06 Mar 2007 20:06 GMT

.....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

Reply to this Message

Dave Peterson - 06 Mar 2007 20:19 GMT

=sum(j12:j42)

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

> .....can it!!
>
[quoted text clipped - 11 lines]
>
> Bob

Signature

Dave Peterson

Reply to this Message

Bob Holdford - 06 Mar 2007 20:46 GMT

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)
>
[quoted text clipped - 17 lines]
>>
>> Bob

Reply to this Message

Dave Peterson - 06 Mar 2007 21:15 GMT

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.
>
[quoted text clipped - 31 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Bob Holdford - 06 Mar 2007 21:39 GMT

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).
[quoted text clipped - 43 lines]
>> >
>> > Dave Peterson

Reply to this Message

Dave Peterson - 06 Mar 2007 21:46 GMT

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.
>
[quoted text clipped - 53 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 06 Mar 2007 21:53 GMT

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.
[quoted text clipped - 65 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message