Add time when working 3rd shift



Can someone pelase tell me a formula that can give me 2 difrent total hours worked for a 3rd shift employee...Here is what I export from another source.
This is what an example looks like "Oct 22, 2012 10:30:00 PM Oct 23, 2012 9:00:00 AM"
I want one formula to calculate (add time worked) from10:30pm - 12:00am for oct 22 and another formula to calulate the rest of the time wich in this case is 12:00am - 9am of Oct 23rd
So 2 difrent formulas 2 difrent rows is fine

Thank you

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question