I think you need to word the problem more precisely, especially what you
mean by percentage
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Chris" wrote in message
...
how do i calcalate hours above 7am and below 19:00am leaving 12 hrs on a %
basis.
So if i work 06:30 and finsih at 18:30 that is 30 minutes as a % rate
Also if i work 14:00 and finish at 2am so thats is 7hours % rate