Thread
:
Convert to hrs:min
View Single Post
#
1
June 3rd, 2010, 11:33 PM posted to microsoft.public.excel.misc
da
external usenet poster
Posts: 120
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
da
View Public Profile
View message headers
Find all posts by da
Find all threads started by da