Converting imported hr/min/sec to excel

G

Gerry St

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
 
R

Roger Govier

Hi Gerry

If your imported data is in cell A1
in cell B1
=--(LEFT(A1,2)&":"&MID(A1,4,2)&":"&RIGHT(A1,2))
Format>Cells>Number>Time (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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Sum in Excel 1
Converting hr min sec into numbers 5
Converting time format in hours mins to minutes 4
Displaying time gaps 6
how do you install Excel to Word converter? 1
Office 2003 -> Office 2007: Import Data fr Access into Excel 0
Radical color chages on importing a worksheet (Excel 2010)? 0
Convert imported text to date time 2

Top