I would create a dummy column and insert

=(60*VALUE(LEFT(TEXT(A1,"0000"),2))+VALUE(RIGHT(A1 ,2)))/60/24

and then format the row as time. You can then copy and paste special
selecting values to remove the formula. Don't forget to format as time again
where you pasted. You can then delete all unecessary columns.

"batfish" wrote:

I imported some data into excel that is in a dbf file. two of the columns
contain time information expressed in the military format (No : separating
the hours and minutes). When I calculate the difference, the answer is in
base 100 format ie from 1300 hours to 1400 hours is 100 units, not 60. How
do I either convert these cells into a time format that will properly format
the answer or take the answer given and have it make sense. ANything less
than 1 hour reads okay, anything over is not.