time in Excel is saved as decimal parts of a day. so 12 noon is 0.5 and 6am
is 0.25
so 08:44 is 0.363888889

use the HOUR() function and MINUTE() functions to split out those parts
separately

I don't get how you want to sum these. please could you re-phrase the
question?



"Ron" wrote in message
...
I need to sum the length of tim in column d: according to the hour in
column
B:.

Column B = 8:44:00AM or 8:44AM (from a text file, general format.)
Column D - 16:38, stored as 4:38:00 PM (formatted h:mm, but actually
min/sec)

I have already changed B to military with:
VALUE(IF(ISNA(CONCATENATE(LEFT(B3,LEN(B3)-2),"
",RIGHT(B3,2))),"",CONCATENATE(LEFT(B3,LEN(B3)-2)," ",RIGHT(B3,2)))) (Not
my
formula, but the damn thing works)

B: is sorted so the hours are in order. so I'm sure there is a better way
than pasting about 2000 formulas in a spreadsheet

Thanks,

Ron