calculation

C

Chris Watson

I have a cell with a start time and a cell with a finish time,
the start time is: ie 05:00 and the finish time is: ie 20:00.
I have the formula for total time worked but im wanting a formula that
will calculate the hours worked before 06:00 and after 18:00
as these are overtime hours and need to be calculated seperately.

Can anybody help please

Chris
 
P

Peo Sjoblom

Start time in A2, end time in B2

OT would be

=MAX("06:00"-A2,0)+MAX(B2-"18:00",0)

now that means the start at 05:00 but end at 12:00 would still get OT,
 

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

Calculate elapsed time excluding specific timeframe 10
calculate overtime at 2 different rates 5
how do I calculate a week days hours with the 24hour clock 5
Time difference calculation 5
TIME CALCULATION 5
Conditional Time Calculation 10
Calculating time for 3rd shift 4
Break Calculation 1

Top