number to time format when digit length varies
I am struggling to convert following "number" format cells as 24 hrs "time"
format (hh:mm)
516
2306
637
202
2353
300
3
6
It should then appear as:
05:16
23:06
06:37
02:02
23:53
03:00
00:03
00:06
Any help will be a great relief.
Thanks/regards,
|