mm/dd/yy hh:mm:ss calculations

Hi,
I wonder if anyone can help me. I have a long list of data in the format mm/dd/yy hh:mm:ss , a start time and a finish time. What I want know is; what hours the guys worked between 05.30–18.00 and 18.00–5.30 am.

I’m no excel expert so the more simple the explanation the better. Any help greatly appreciated

Example data

Cell A1 Start time= 07/30/2011 5:00:00 AM

Cell A2 finish time= 07/31/2011 23:59:00 PM

Cell A3 Total time= 42:39:00


Further Comment

Thanks for the response, I may have not explained my problem quite correctly, or I have made an errror in copying the formula.

A1 = 1/1/2013 12:00:00 AM

A2 = 1/2/2013 2:00:00 AM

A3 = 26 hours in total (A2-A1)

I wanted to know the hours worked between 6.00 am and 18.00, so in this example out of 26 in total 12 hours between 6.00 am and 18.00

If they are stored as Excel dates

=(end time - start time) * 24

Hi Davids8075

Assuming data is set up as the following:
A1: Start time
B1: Finish time

Two methods;
1: =MOD(B1-A1,1)*24
2: =(IF(B1<A1,B1+1,B1)-A1)*24

And format cells as general.