View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Formula for Excel

=SUM(A1:A3) or =A1+A2+A3
Format the result as [h]:mm to get the result as 25:00

If you want the result as a number of hours to use in subsequent
calculations, use =SUM(A1:A3)*24 or =(A1+A2+A3)*24
and in this case format the result as General or Number, not as time.
--
David Biddulph

"Dannigirl" wrote in message
...
How do I add times together in order to get the total hours I worked?

i.e.: I worked 8hrs and 57minutes (8:57) on Monday, 8hrs and 26minutes
(8:26) on Tuesday, and 7hrs and 37 (7:37) minutes on Wednesday.

What formula could I use to get the total hours I worked? The formula
should
tell me I worked a total of 25 hours.

Thank you in advance.