I need a formula to tell me how many hours and minutes are between 10:00 pm to 8:00 am
if in cell B2 I have 10/18/11 8:17 AM and in cell C2 I have 10/19/11 10:51 AM the formula should show 10 hours
if in cell B2 I have 10/18/11 5:00 PM and in cell C2 I have 10/19/11 4:45 AM the formula should show 6 hours and 45 minutes
Can this be done using excel 2003? Thanks
if in cell B2 I have 10/18/11 8:17 AM and in cell C2 I have 10/19/11 10:51 AM the formula should show 10 hours
if in cell B2 I have 10/18/11 5:00 PM and in cell C2 I have 10/19/11 4:45 AM the formula should show 6 hours and 45 minutes
Can this be done using excel 2003? Thanks