View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
UM Win UM Win is offline
external usenet poster
 
Posts: 2
Default 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,