Howdy all,

I am making a timesheet, and could use some help for one last function. I am limited by having to make the printed report look like the current time sheet.

Basically you type your start time and your end time into the spreadsheet. What I need is an equation or function that would identify how many hours were worked during the shift differential time period and put that number into that shift differential's column for that day.

The two shift differentials occur between 1600 and 2400, then from 0000 to 0800.

bty I'm using Excel 2003.

Thanks for any suggestions, and let me know if you need additional clarification.