One mo

=--(TEXT(A1,"00\:00")&":00")

And format as hh:mm



UM Win wrote:

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,

--

Dave Peterson