Calculating hours in a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dasco - 13 Apr 2007 22:37 GMT

I have a simple spreadsheet that totals the hours from start to end time ie
a1+a2. However when I try to calculate total hours in a column ie
sum(L2:L36), the answer is not correct. What am I doing wrong?

Thanks - Dave

Reply to this Message

Peo Sjoblom - 13 Apr 2007 22:44 GMT

Use custom format [hh]:mm
that way the hours will not start over again after 24

Signature

Regards,

Peo Sjoblom

>I have a simple spreadsheet that totals the hours from start to end time ie
>a1+a2. However when I try to calculate total hours in a column ie
>sum(L2:L36), the answer is not correct. What am I doing wrong?
>
> Thanks - Dave

Reply to this Message

Dasco - 13 Apr 2007 22:52 GMT

Thanks Peo - I'm already using custom [hh]:mm Any other ideas?

> Use custom format [hh]:mm
> that way the hours will not start over again after 24
[quoted text clipped - 4 lines]
>>
>> Thanks - Dave

Reply to this Message

Peo Sjoblom - 13 Apr 2007 23:39 GMT

What do you mean by not correct?

Check if all the data is numerical

=ISNUMBER(A2)

should return TRUE if you have Excel times

Signature

Regards,

Peo Sjoblom

> Thanks Peo - I'm already using custom [hh]:mm Any other ideas?
>
[quoted text clipped - 6 lines]
>>>
>>> Thanks - Dave

Reply to this Message

Dasco - 14 Apr 2007 08:16 GMT

By being 'not correct' I mean that when I total the column the result is
inaccurate ie I can see that the total is more than 24 hours but it's
telling me it's only 06:15.

Regarding =ISNUMBER(A2), this is reading TRUE

Thanks Dave

> What do you mean by not correct?
>
[quoted text clipped - 14 lines]
>>>>
>>>> Thanks - Dave

Reply to this Message

Dave Peterson - 14 Apr 2007 12:50 GMT

Try formatting the cell with the formula as:
[hh]:mm:ss

> By being 'not correct' I mean that when I total the column the result is
> inaccurate ie I can see that the total is more than 24 hours but it's
[quoted text clipped - 32 lines]
> >>>>
> >>>> Thanks - Dave

Signature

Dave Peterson

Reply to this Message

Peo Sjoblom - 16 Apr 2007 16:30 GMT

That is what you get if you just have hh:mm as format, check again and this
time select custom format and type in [hh]:mm

Signature

Regards,

Peo Sjoblom

> By being 'not correct' I mean that when I total the column the result is
> inaccurate ie I can see that the total is more than 24 hours but it's
[quoted text clipped - 22 lines]
>>>>>
>>>>> Thanks - Dave

Reply to this Message