how do i calcalate hours above 7am and >19:00am leaving 12 hrs

C

Chris

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
 
B

Bernard Liengme

I think you need to word the problem more precisely, especially what you
mean by percentage
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation of peak and off peak hours 1
Hours worked on job/per shift 1
how do I let a macro repeat itself in excel 1
excel timesheet and drop down boxes 3
How do I find the amount of hours between times? 1
How do I convert times from hours to minutes? 5
Time Card 1
Evaluating Week No. 8

Top