Time duration between dates

[Noz2k]

so I have a list of dates like 25/07/2011 22:22 in column b and a list of dates in column c in the same format.

I want to get a the time difference in hours in column E but am unsure how to format the column?

 

[Dannyh1]

Hi Try:

[h]:mm:ss

 

[Noz2k]

afraid not,

that gave me the value 977998:22:13

when both values in B & C are 25/07/2011 22:22

 

[Joneye]

Does this help?
<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">42</td><td style=";">Time</td><td style="text-align: center;;">2:04 PM</td><td style="text-align: center;;">4:30 PM</td><td style="text-align: center;;"></td><td style="text-align: right;;">02:25</td></tr></tbody></table><p style="width:6.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">1. Formulas</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C42</th><td style="text-align:left">=NOW(<font color="Blue"></font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F42</th><td style="text-align:left">=MOD(<font color="Blue">D42-C42,1</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Dannyh1]

strange, I get 0:00:00

what is your formula to calculate difference?

 

[Noz2k]

strange, I get 0:00:00

what is your formula to calculate difference?

Sorry, so do I. I'd just really stupidly referenced the wrong column. Thanks for the help