I have a xls file where a timevalue, in hours and minutes is across two columns (L, M)
visually it looks good, there is no space in the field but somehow excel thinks the part before the colon in L and part after is M, while you can't see that in looking at the file
the values look like 1:00 or 2:45 or 6:15
there are about 20 lines per group and the desire would be to total the hours and minutes but it does not work as the data is somehow across two columns
have attempted to copy and paste, that also fails with some message about unequal formatting or such. I really don't want to retype this data, as it's an export file from another system but would like to hear some suggestions for
1) how to combine, either via vba or manually the columns L and M and
2) how to sum the hours into a HH:MM format. the number for a month can be large, like 1400:40 would be 1400 hours and 40 minutes
visually it looks good, there is no space in the field but somehow excel thinks the part before the colon in L and part after is M, while you can't see that in looking at the file
the values look like 1:00 or 2:45 or 6:15
there are about 20 lines per group and the desire would be to total the hours and minutes but it does not work as the data is somehow across two columns
have attempted to copy and paste, that also fails with some message about unequal formatting or such. I really don't want to retype this data, as it's an export file from another system but would like to hear some suggestions for
1) how to combine, either via vba or manually the columns L and M and
2) how to sum the hours into a HH:MM format. the number for a month can be large, like 1400:40 would be 1400 hours and 40 minutes