I have times in H1:Q1 which are formatted as hh:mm but are actually text
E.g. 04:20. 05:11
I also have dates in h3:Q3 which are formatted as dd-mm-yy are also text
I would like VBA to convert the times to proper times and dates to proper dates
Thanks
E.g. 04:20. 05:11
I also have dates in h3:Q3 which are formatted as dd-mm-yy are also text
I would like VBA to convert the times to proper times and dates to proper dates
Thanks