Thread: Add up hours
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar[_2_] RichardSchollar[_2_] is offline
external usenet poster
 
Posts: 76
Default Add up hours

Hi

Just add up all your days' formulas like

=SUM(E4:E26)

assuming they are in E24:E26. What you will probably want to do is to
format this formula cell with a custom number format of:

[h]:mm

So that you get the value in total hours/minutes (ie this number
format will display 2 days, 6 hours as:

54:00

Hope this helps!

Richard

Smiley78 wrote:
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?