Count in Hours

[Steven1985]

Hi,

Can anyone help count between cells -

30/08/2011 15:07

01/09/2011 15:08

Difference is 2 days 0 hours 1 min

The formula used is - =IF(AO3="","",AO3-A3) but i now need to include within the formula to count working days ONLY. I have created a list on a 'controls' tab A10:A47.

Any idea how i can do this?

Thanks

<TABLE style="WIDTH: 57pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=76 border=0><COLGROUP><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><TBODY><TR style="HEIGHT: 15.75pt; mso-height-source: userset" height=21><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 57pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #dbeef3" align=right width=76 height=21>

</TD></TR></TBODY></TABLE>

 

[Derek Brown]

Have a look at the following - it may provide the answer for you:
http://www.cpearson.com/excel/DateTimeWS.htm