|Ok, first of all make sure that the cells containing the data are formatted in time format mirroring what you have showing in your question (specifically, HH:MM:SS).|
Next, use this formula to calculate out the times:
What this will do is check to see if the second number (01:03:00 in your example) is less than the first number (22:46:00 in your example). If it is, then it will add a 1 to it, essentially adding a day to the second number and allowing it to correctly calculate overnight time windows.
Please let me know if you have any questions or need more assistance.
IT Desktop & Network Consultant - MOS Master Certified, MCP, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +