| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Converting imported hr/min/sec to excel
I am trying to convert time entries from an external source (hh/mm/ss) to calculate in excel. What is the easiest method of doing this? I am not sure of the properties of the external report but is seems to be very similar to word pad.
Thanks, Gerry |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Converting imported hr/min/sec to excel
Hi Gerry
If your imported data is in cell A1 in cell B1 =--(LEFT(A1,2)&":"&MID(A1,4,2)&":"&RIGHT(A1,2)) FormatCellsNumberTime (hh:mm:ss) Copy formula down as required If you need to sum the times calculated in column B, format the cell with the summation formula as [h]:mm to allow it to sum past 24 hours. -- Regards Roger Govier "Gerry St" wrote in message ... I am trying to convert time entries from an external source (hh/mm/ss) to calculate in excel. What is the easiest method of doing this? I am not sure of the properties of the external report but is seems to be very similar to word pad. Thanks, Gerry -- Gerry St |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| dealing with csv imported file in excel | Excel Discussion (Misc queries) | |||
| Converting numbers stored as dates to text in Excel | Excel Discussion (Misc queries) | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
Linear Mode
