| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hh:mm to mm:ss
I have scanned a telephone account which shows the duration of a call as
min:sec (eg.15:35). Using an OCR program I have imported this data into Excel which picks the time up as hh:mm format. is there anyway to get Excel to read it as minutes and seconds instead of hours and minutes without going thru every record and adding a 0: (to hold the hour place)??? Thanks Helen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
| How do I add time (in mm:ss) from multiple worksheets? | Excel Worksheet Functions | |||
| The HH:MM function | Excel Discussion (Misc queries) | |||
| Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
| how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions | |||
Threaded Mode
