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

Add Hours by Looping through Data Q 27
Calculating occupational sick pay entitlement 0
Calculation of Overlap Outage Hours 17
Extract data from previous week, previous two weeks, etc. 2
Calculation of peak / off peak hrs v2 0
Aggregate the time data (mm/dd/yyyy:hh:mm:ss) into the 3 hours range 0
15 minute data to daily data 1
convert hrs into decimal 8

Top