Help
I need a formula that would calculate time for my 3rd shift employees.
This is what I export from another source
The columns look like this
Nane Shift Start Shift Ends
Doe, John "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM"

I need a formula that will calculate
*Howmany hours were worked on Oct 22 (example on this it would be 10:30p-12am= 1.50
*Howmany Hours were worked on Oct 23rd (Example on this one it would be 12am-9am=9hrs

Can someone please help?