Military time subtraction

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

you guys are life savers!!