| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import into excel (Time)
Hello, I imported several columns to a spreadsheet. One column is "Time
hh:mm:ss". When I attempt to add the time across multiple cells it comes up "0".If I double click the cell, it changes the format of the cell and calculates. Example: A1 = 00:05:00 After I double click A1 = 0:05:00 B1 = 01:02:00 After I double click B1 = 1:02:00 Total Time = 0 Total Time = 1:07:00 I do not understand why this is happening!! P.S. I formatted the cells for time "hh:mm:ss" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import data from website everyday at certain time... | Excel Discussion (Misc queries) | |||
| Add leading 0 to csv import text/time H:MM | Excel Discussion (Misc queries) | |||
| I want to import a web query into the same cells each time | Excel Worksheet Functions | |||
| Import csv data and convert to TIME format | Excel Worksheet Functions | |||
| how do I import data (distance and time) from MapPoint to Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
