All of you are great! I have finally gotten it to work. One last question
though. When adding the column to get the total number of hours the result
is strange. I am adding
12:35
10:30
12:10
9:20
10:15
but the total comes out as 6:50 instead of 54:30. I have read the other
threads but can't seem to get the other examples to work. It appears that I
can't go beyond 24 hours.

"Gord Dibben" wrote:

Time in Excel is always hh:mm:ssAM/PM no matter how you format it.

hhmm is still hh:mm:ss

hh:mm is still hh:mm:ss

Just do your subtraction in the normal manner as Sandy points out.


Gord Dibben MS Excel MVP

On Sat, 16 Feb 2008 11:35:01 -0800, Pattio
wrote:

I have 5 cells in a row (A1 - A5). I need to subtract, in military time, A1
from A2 and then A3 from A4 and the total should be in A5 as standard time.
Cells A1-A4 are formatted as hhmm and cell A5 is formatted as hh:mm.