On Mon, 15 Dec 2003 14:21:08 -0800, "Jake Swarty" wrote:

I would like to be able to substract entry of two military times and come up with the difference in Hours and tenths of an hour. Example 0945-0800 = 145 converted to 1.75 hours.

With 0800 in A1 and 0945 in A2:

=DOLLARDE(A2/100,60) - DOLLARDE(A1/100,60)

If the DOLLARDE function is not available, and returns the #NAME? error,
install and load the Analysis ToolPak add-in.




--ron