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?
|