Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Imported time text to seconds
I am importing time data, which imports in the hh:mm:ss format (or omitting
hh and mm if 0 value) to my eyes, but in the general format, so those entries which could represent a time of day are interpreted as a time of day in the AM, and that which could not be a time of day is interpreted as text. e.g. "4:00" in a cell shows as "4:00 AM" in the formular bar and :40 shows as :40 both places, but is formatted as text. Prior to import, and to the eyes after import in the cells themselves, there are five types of entries: 00:00:00 0:00:00 00:00 0:00 :00 How can I convert these text strings and time values to seconds? Can it be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seconds into time | Excel Worksheet Functions | |||
How do I change a minutes and seconds as a 2400 time to seconds? | Excel Worksheet Functions | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
problem working with time data imported from text file | Excel Worksheet Functions |