How to fix a duration with missing colon :
Hi all, I have an issue that I haven't encountered before... I have an Excel file with 87 columns of durations that should be in hh:mm However, they are in hhmm or hmm <-- note the missing : If the duration is less than 10:00 it is three figures (9:59 is entered as 959)If the duration is more than 9:59 it is four figures (11:52 is entered as 1152) I can handle this if it were 1 or 2 columns, b...