Adding time

[Stef]

In a list I record the time spent for a specific activity daily. At the end
of the month I would like to add up these the records to a monthly total. The
record is very simple: In cells A1- A 31 I write on the format HH:MM. What's
summing up formula for this?

 

[Per Jessen]

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

 

[Stef]

I only get the result: 00:00:00
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?

 

[Per Jessen]

Hi

If the sum range holds any time value, the formula cell should show the time
total.

Regards,
Per

I only get the result: 00:00:00
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly
total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?

 

[Stef]

If I add two values in the list for example A1+A2 it shows the correct
result. The formula "SUM" does not seem to fix this
--
Stef

Hi

If the sum range holds any time value, the formula cell should show the time
total.

Regards,
Per

I only get the result: 00:00:00
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

"Stef" <[email protected]> skrev i meddelelsen
In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly
total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?

 

[Stef]

The list has been exported from Access 2003 to Excel. Can this be part of the
problem? If I write new time values in an Excel sheet the SUM-formula works
--
Stef

Hi

If the sum range holds any time value, the formula cell should show the time
total.

Regards,
Per

I only get the result: 00:00:00
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

"Stef" <[email protected]> skrev i meddelelsen
In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly
total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?

 

[David Biddulph]

You've probably got text instead of real times.
--
David Biddulph

The list has been exported from Access 2003 to Excel. Can this be part of
the
problem? If I write new time values in an Excel sheet the SUM-formula
works
--
Stef

Hi

If the sum range holds any time value, the formula cell should show the
time
total.

Regards,
Per

I only get the result: 00:00:00
--
Stef


:

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result
in
hours.

Regards,
Per

"Stef" <[email protected]> skrev i meddelelsen
In a list I record the time spent for a specific activity daily. At
the
end
of the month I would like to add up these the records to a monthly
total.
The
record is very simple: In cells A1- A 31 I write on the format
HH:MM.
What's
summing up formula for this?

 

[Stef]

This customized format works alright, though my format looks [t]:mm:ss.
Thanks a lot
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?

 

[Per Jessen]

Hi Stef

Thanks for your reply. Did you solved the sum problem ?

Best regards,
Per

This customized format works alright, though my format looks [t]:mm:ss.
Thanks a lot
--
Stef

Hi

=Sum(A1:A31)

The cell has to be formatted as custum : [tt]:mm, to show the result in
hours.

Regards,
Per

In a list I record the time spent for a specific activity daily. At the
end
of the month I would like to add up these the records to a monthly
total.
The
record is very simple: In cells A1- A 31 I write on the format HH:MM.
What's
summing up formula for this?