Thread: Adding time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Adding time

Hi

=Sum(A1:A31)

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

Regards,
Per

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