On Feb 5, 9:06 am, flebber <flebber.c...@gmail.com> wrote: > 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?
Just checking in on any ways to manage this as a time format in Excel and Access? -- ---------------------------------------------------------------------------------- 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
