On Feb 3, 10:18 pm, flebber <flebber.c...@gmail.com> wrote: > I have a table of data containing name and time information. Excel and > Access can understand it whilst it is in a format such as 12.2 or 11.8 > but when it is in a minutes format it cannot. > > For example I have a macro which I am still working on which will tidy > up an rtf to be a table recognisable and reusable as a table to import > into Access. However I am thinking of throwing out the totals > column(not calculated by me) as Access can't understand it from my > Excel table. It looks like this where 01 is 1 minute, 10 is seconds > and .5 .7 etc are parts of a second and important.A copy of my full > table herehttp://www.mediafire.com/file/6cm903g8yzazj9c/3rdDraft.xlsx > > Total > 01:10.0 > 01:10.5 > 01:10.7 > 01:10.8 > 01:10.8 > 01:11.1 > 01:11.4 > 01:11.5 > 01:11.6 > 01:11.6 > 01:12.3 > 01:14.8 > > Any ideas?
No ideas how I can use Excel to format this so Access could understand it? Would there be a way to convert it to seconds format? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
