Time Calculations:keep track

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.

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?

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.

--
HTH

Bob Phillips

"craigj" <craigj.1vkb2a_1127059501.0575@excelforum-nospam.com> wrote in
message news:craigj.1vkb2a_1127059501.0575@excelforum-nospam.com...
>
> 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/2...lculate2ch.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?
>
>
> --
> craigj
> ------------------------------------------------------------------------
> craigj's Profile:
http://www.excelforum.com/member.php...o&userid=27355
> View this thread: http://www.excelforum.com/showthread...hreadid=468616
>

Thanks, that works great, except you forgot to divide the whole thing by 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 - how would that be applied?