Thread
:
Convert to hrs:min
View Single Post
#
1
Posted to microsoft.public.excel.misc
DA
external usenet poster
Posts: 104
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
Reply With Quote
DA
View Public Profile
Find all posts by DA