Need help with an Excel formula

I am trying to make a sheet for recording my shift timings and credit points earned for each shift. So the idea is that suppose Cell B3 to B30 contain my duty...