Calculating time for 3rd shift
On Thursday, October 25, 2012 9:49:04 AM UTC-5, wrote:
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 he
Thank you that works
|