Time Calculations

[craigj]

I'm creating a spreadsheet to keep track of the hours I work and to
calculate the pay.

'Here's roughly how it'll look.'
(http://img249.imageshack.us/img249/2935/paycalculate2ch.jpg)

How would I go about calculating the "normal", "evening" and "premium"
hours, where normal, evening and premium are 0600-1800, 1800-0000,
0000-0600 respectively?

 

[Bob Phillips]

E5: =IF(B5<C5,MIN(C5,1800)-MAX(B5,600),1800-B5)
F5:=IF(B5<C5,MAX(C5-1800,0),600)
G5:=MAX(0,600-B5)+IF(B5<C5,0,C5-0)

I have accounted for the break as you give no indication in what period it
was taken.

 

[craigj]

Thanks, that works great, except you forgot to divide the whole thing b
100 each of the totals. e.g.
=(IF(B6<E6,MIN(E6,1800)-MAX(B6,600),1800-B6))/100

So if I was to add break-start and break-end columns like
'this' (http://img43.imageshack.us/img43/7485/pay1cl.jpg) - how woul
that be applied

 

[craigj]

bump?

The formula doesn't seem to calculate the Evening or Premium hours.