Hi guys,

how to insert formula that make use of the time range of 0800 hrs - 2300 hrs and calculate:

number of hours fall between 0800 hrs - 1700 hrs will be record in C2

number of hours fall between 1800 hrs - 2400 hrs will be record in D2

number of hours fall between 0000 hrs - 0800 hrs will be record in E2

Your help will be greatly appreciate...
Lix