time calculations

C

craigj

I have a spreadsheet that 'looks like this'
(http://img43.imageshack.us/img43/7485/pay1cl.jpg) to be used for
calculating the hours I work.

The "normal", "evening" and "premium" hours refer to 0600-1800,
1800-0000, 0000-0600, respectively.

The formula for F6 would be:
=IF(B6<E6,MIN(E6,1800)-MAX(B6,600),1800-B6)
(not taking into account the break)

How would I change this formula to deal with the breaks and hence what
would be the correct formula for the evening and premium hours.

Sorry, I'm having a real hard time getting my head round this.
 
C

craigj

Bob said:
Aren't you missing the formulae for overtime and premium
Click to expand...

Yes, I am. I don't know what the formula is. The formulae you provide
previously don't work, other than the one for regular hours
 

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

Time Calculations 3
time sheet and majority hours 8
Calculating specific increments of time across days 2
time calculations 2
Rounding time UP to nearest fourth-hour 4
calculating pay rates for different times of the day 4
Excel Time Rounding in Excel 2
How do I create the formula for this calculation? 1

Top