Quote:
Originally Posted by da
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
|
If A1 has 1545
=(Left(A1,2)&":"&Right(A1,2))*1
Then format the cell as Time with 13:30 format