Complex counting time function

Hi,

I am trying to work out a function for a timesheet spreadsheet that works out how many hours were worked in the day shift and how many hours were worked in the night shift.... The change over time is 5pm.
Eg. Pete starts at 11am and works till 8pm. So he works 6hrs in the day and 3hrs in the night.

Staff name:------Time Start:-----Time Finished:------Day Hrs:----Night Hrs:
Pete---------------11am----------------8pm-----------------??--------------??

I cant get my head around a function that will work out the day and night hours from the input of the starting and finishing hours. Any help would be much appreciated.

Thanks

Alex

Please Login or Register  to view this content.