Hi,
Sorry this is probably an easy one but having alittle trouble working it out.
I have daily hours that I need to break down to normal time, time & half and Double time.
Normal Time = upto 8 hours
Time & Half = upto 2 hours after first inital 8hrs
Double Time = anything over 10hrs for day
Date Hrs NT T5 DT
5/9/12 11.50 8 2 1.50
5/9/12 7.50 7.5
6/9/12 9.00 8 1
6/9/12 10.00
6/9/12 12.00
6/9/12 12.00
8/9/12 10.00
8/9/12 10.00
Cheers,
Ral
Bookmarks