Converting a text time into a time format.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Here's my problem. I have a text field that is "00:13:45" and i would like to covert that into a time field of "hh:mm:ss" in order to calculate totals/averages. Currently if i change the format of the cell to a hh:mm:ss format it will not change the actual data in the field until you activate(F2) in each cell. I'm familiar with the Timevalue() formula but i would like to avoid adding more columns into the spread sheet

Is there a simple way to do this with out having to activate(F2) each of the fields in order for the time to convert. Any one know if i can create a macro to activate each field in a range to make it any quicker

Any help would be appreciated

Thanks
Chivas
 
Hi
try the following
- format your column as Time
- select an empty cell and copy this cell (CTRL+C)
- select your columns with your time values
- goto 'Edit - Paste Special' and choos the action 'Add'
 

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

Excel 2007 time calculation 1
Shortcut for current Time in hh:mm:ss 2
Converting time formats into actual time(minutes) 2
convert time 2
hh:mm:ss keeps converting to a date 4
MROUND time 2
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm 1
Calculating Times 3

Back
Top