| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert time imported as text to time format for calculations
I imported some data into excel that is in a dbf file. two of the columns
contain time information expressed in the military format (No : separating the hours and minutes). When I calculate the difference, the answer is in base 100 format ie from 1300 hours to 1400 hours is 100 units, not 60. How do I either convert these cells into a time format that will properly format the answer or take the answer given and have it make sense. ANything less than 1 hour reads okay, anything over is not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert [h]:mm sum total format to number format | Excel Worksheet Functions | |||
| Everytime I need to format cells or text, Excel 2003 takes a lot of time or free | Excel Discussion (Misc queries) | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| Help Q: Entering 7 p time format, does not convert to 19:00 | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
