P
Piers 2k
Hi folks,
For thousands of rows, time has been entered as 10.15 or 9.30. These are
correct times, as in quarter-past-ten and nine thirty. To perform
calculations, I obviously need to have a : (semi-colon) not a . (full-stop)
Find and replace won't work because 9.3 (nine thirty) comes up as 9:03.
I can write a macro, but trying to avoid since it's for someone else.
Any ideas?
TIA,
Piers
For thousands of rows, time has been entered as 10.15 or 9.30. These are
correct times, as in quarter-past-ten and nine thirty. To perform
calculations, I obviously need to have a : (semi-colon) not a . (full-stop)
Find and replace won't work because 9.3 (nine thirty) comes up as 9:03.
I can write a macro, but trying to avoid since it's for someone else.
Any ideas?
TIA,
Piers