Military time subtraction

How can I subtract military time over a date range, and get a minute output.

ex. 2300 on 01/01/08 is subtracted from 0100 on 01/02/08 to get 120 minutes.

I can't even get to the point of getting a positive number, much less adding a formula to give me minutes.

Someone please help!!

Just subtract the smaller from the larger, and format as [m]

Do you have times shown as 2300, without a colon, or 23:00 with a colon. Do you have the dates in the worksheet or just times? If you have dates then are they in the same cells as the times?

If you have time and date in the same cells (in recognisable time/date format) then you can use shg's suggestion or

=(B1-A1)*1440

format as number

where B1 contains the later time/date and A1 the earlier time/date. If A1 and B1 contain just times in recognisable excel format (i.e. with a colon) try

=MOD(B1-A1,1)*1440

format as number

The times are shown without a colon but if i have to i will go through the spreadsheet and add colon, it will just take me forever, unless someone know how to add colons to an entire column.

say A1 contains 2347

in B1 put =concatenate(left(A1,2),":",right(A1,2)

this gives 23:47

copy down the column

highlight column B, edit copy, edit paste special values

delete column A