Quote Originally Posted by belinda200 View Post
why would this be half an hour?
Tuesday 05:30 to 16:00 (Would be half an hour in total)

Try in D2 and down:
=(VALUE(C2)-VALUE(B2))-0.5

This would be Half an hour due to the time from 05:30 - 06:00