View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DA DA is offline
external usenet poster
 
Posts: 104
Default Convert numbers to hrs: min

Hello
How can I convert the following numbers into hrs:min?
I have tried every possible format (including custom) and I do not get the
results I want (e.g. 15:45 18:40)
I want to get the difference in time between these numbers.
Thank you

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