Column formating

[Kidmon]

I am using excel 2007

I need to format a column that calculates the difference in military time. I have the time calc formula, I need to format the entire column to preform the formula. I currently need to stretch the column's cells down the column and this has proven problematic with inexperienced excel users.

How can I format the column without copying by stretching the cell's formula?

Column J (Time in) Column K (Time out) Column L (Difference of time)
Thanx for you help


NC[TABLE="class: html-maker-worksheet"]
<tbody>[TR]
[TH][/TH]
[TH]J[/TH]
[TH]K[/TH]
[TH]L[/TH]
[/TR]
[TR]
[TH]973[/TH]
[TD="align: right"]10:00[/TD]
[TD="align: right"]10:25[/TD]
[TD="align: center"]0:25[/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010

Cell	Formula
L973	=K973-J973

<tbody>
[TD="bgcolor: #FFFFFF"] Worksheet Formulas [TABLE="class: html-maker-worksheet"]
<tbody>[TR]

</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

 

[GDH]

Hi

Im not sure if i fully understand the question but have you tried converting the data range into a Table? (select data then CTRL + T)

 

[Kidmon]

GHD, Thanx for your interest. Your suggestion using CTRL+T will does not help me. I need fewer key entries to remove the necessity of excel knowledge during data entry. But thank, I learned what CTL+T will do, sure I will use that somewhere in my Excel future.