Thread: Convert to hrs:min
View Single Post
  #1  
Old June 3rd, 2010, 11:33 PM posted to microsoft.public.excel.misc
da
external usenet poster
  
Posts: 120
Default Convert to hrs:min
hello
Is there any way to convert the following numbers to show as hrs:min without
manually insterting a colon?
e.g.15:45 18:40

1545 1840
2015 2300
2045 2105
1700 1815
1825 1840
1850 2000
1835 1900