| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a column of positive numbers to negitive numbers | Excel Worksheet Functions | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Threaded Mode
