Hi,

Im trying to find a time function, formula that will let me key in start of
shift and end of shift then calculate how many hrs I should be paid.

Depending on what time of day I start, I will get paid different rates

ie between 6am and 6pm I get day rate, after 6pm I get night rate, after 8
hrs I get overtime according to what time of day Im working.

Any ideas?