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