Thread: Add up hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Add up hours

=D4-C4

no need for SUMMA when you do subtraction


then if you want to sum the whole month, assume the days are in E4:E34

=SUMMA(E4:E34)


now here's the trick, custom format the result as

[tt]:mm:ss


or else you won't display past 24 hours


--


Regards,


Peo Sjoblom


"Smiley78" wrote in message
...
I have put in the start time 09:30 and when i quit working 18:15 and made a
formula =SUMMA(D4-C4) so that i get how many hours and minutes i work that
day. But how do i add all hours and minutes for each day so i can see how
much i worked whole month?