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

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" <(E-Mail Removed)> wrote in message
news:3F8A398F-34C5-4B42-B01E-(E-Mail Removed)...
> 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

Hi,
Take a look at C Pearson Web

http://www.cpearson.com
Go to topics and look into timesheet

"Chris" wrote:

> 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