Posted by Sturty on August 01, 2001 11:37 AM
when I paste a time value (from an html document) into an excel workbook the results can often be confusing. My problem is if the time value that is pasted is less then a minute or less then an hour. If it is pasted as :SS or :mm:ss (i.e. :33 or :13:12)it may be pasted with a general format. This causes several difficulties when trying to find the average time for something.(In this case hold time in a phone report). Changing the Format could cause the minutes to be placed in the hour column (13:12:00 rather then 00:13:12 [this could make a CEO wonder why people are being put on hold for 13 hours].) Is there a solution to this?