Calculating hours in a column

[Dasco]

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

 

[Peo Sjoblom]

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

 

[Dasco]

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


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

 

[Peo Sjoblom]

What do you mean by not correct?

Check if all the data is numerical

=ISNUMBER(A2)

should return TRUE if you have Excel times


--
Regards,

Peo Sjoblom

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


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

 

[Dasco]

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?

Check if all the data is numerical

=ISNUMBER(A2)

should return TRUE if you have Excel times


--
Regards,

Peo Sjoblom

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


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

 

[Dave Peterson]

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
telling me it's only 06:15.

Regarding =ISNUMBER(A2), this is reading TRUE

Thanks Dave

What do you mean by not correct?

Check if all the data is numerical

=ISNUMBER(A2)

should return TRUE if you have Excel times


--
Regards,

Peo Sjoblom

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


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

 

[Peo Sjoblom]

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

--
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
telling me it's only 06:15.

Regarding =ISNUMBER(A2), this is reading TRUE

Thanks Dave

What do you mean by not correct?

Check if all the data is numerical

=ISNUMBER(A2)

should return TRUE if you have Excel times


--
Regards,

Peo Sjoblom

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


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