should be simple...but

[plzhelp]

i am on a tight deadline and after weeks of crunching data i would hate for this task to fall apart over simple formulas. i need to know if i can select 1 column and subtract the value in another column from it, and have the total displayed in a seperate column. the only trick to this is that the colums are military time and i dont know how to change the formating from general to military time. also once the format is changed can i get the subtracted totals for multiple rows all at once or do i need to go one at a time. any help would be greatly appeciated

 

[justme]

If I understand your post correctly the following should help.

To change the formatting to military time, right click in the cell and choose format cells. Choose Time in the category and you will see your choices on the right.

When subtracting your columns I assume you are looking for number of hours between the columns. Your formula will look something like (cell 1 - cell 2)*24

 

[AnAnalyst]

By military time I assume you mean that 9am would appear as 0900 and 6pm would appear as 1800?