Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting time :: Excell 2007
Hello, I am copying data from a table in a webpage and am having difficulty
in converting the minutes and seconds. Example 2836:24:00 is really 2836 minutes 24 seconds and who knows what the 00 is. I have tried [mm]:ss and that returns the real minutes as if calcualated in hours. Another example is 16:10 which is 16 minutes 10 seconds. I need to convert these to example to the folowing format and am lost as to how to do it.. 2836.4 Minutes and 16.17 minutes I welcom all advise and help.. Thanks Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
Excell functions for converting column data | Excel Worksheet Functions | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel |