Hi, Im setting up a spreadsheet for payroll which so far has start time,
end time, total hrs worked and time worked minus break time.

I need to set up a function to look at the working times and if between
6am and 6pm calculate number of hrs worked at day rate, then if between
6pm - 6am calculate number of hrs worked at night rate.

any ideas?

thanks


--
scarlett1
------------------------------------------------------------------------
scarlett1's Profile: http://www.excelforum.com/member.php...o&userid=17495
View this thread: http://www.excelforum.com/showthread...hreadid=384375