Hi Franz Verga,
Thx for ur help, its really solve my prb, but one thing which i want to ask,
why u add 1+ ?
--
Not Even The Wise Can See All Ends --- Tolkien



"Franz Verga" wrote:

Nel ,

Hi Ali,

you have to remember that Excel counts time in day, so the solution to your
problem should be:

in E1: =(1+(C1+D1)-(A1+B1))*24 to have the number of hours;
in F1: =E1*60 to have the number of minutes;
in G1: =(24*7*60-F1)*100/(24*7*60) to have the weekly percentage.




--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy