• Microsoft Excel formula: Sum the column of times

    I want to know the excel formula to sum the column of times (in Hr:mm) format. for e.g. if times are 10.20, 10.10, 10.25 and 2.10 it should result as 33.05 i.e total no. of hrs and minutes.

    shivasanjay3,195 pointsBadges:
  • Downloading from AS/400 to Excel

    I have just being informed by a senior employee that it is wrong to download from AS/400 to Excel, that it gives the staff the opportunity to alter data. Please help with answers that I can use to table my case for either for or against. Reference please

    Ebejale5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • Excel Spreadsheet to i5 Physical File

    What's the best way to upload an Excel Spreadsheet to the i5? I've been trying to use XLPARSE2 but have experienced a lot of problems with hung up jobs and such. At first, I thought it was authority. But, that's not the case. Currently running V6R1.Thanks, Dave

    thedaveeffect10 pointsBadges:
  • Retrieving missing Excel data

    I had an excel file with 10 worksheets on it. I opened the file yesterday and found the whole 10 worksheets missing from the file. What could have caused it and is there a way to retrieve this data back to the file?

    Tess695 pointsBadges:
  • Running display program using macro and input from spreadsheet

    Is there a way to create a macro (either from the iSeries or Excel) to copy/paste data from a spreadsheet into an iSeries screen and then invoke keystokes to perform an action within the interactive program?

    KevinCmyrgroup15 pointsBadges:
  • QSYSPRT

    Hi , A program generated two reports.There is a job that runs every monday , and these report are generated every week.They are copying the data in the report to a work file in Qtemp by the command CPYSPLF .Then they copy the records from work file to Qsysprt by CPYF. My queries are , is this...

    Shobi40 pointsBadges:
  • Excel file for big data analytics

    Can you please provide me with the Excel file sample for big data analytics with real world examples.

    khannamoney5 pointsBadges:
  • Business Objects 12.1 and Office 2010 compatibility

    How can I determine if BO 12.1.0 is compatible with Excel 2010?

    vballkitty5 pointsBadges:
  • Download data from iSeries to Excel

    How do I download data from iSeries to Excel?

    lr538615 pointsBadges:
  • Pull data from AS/400 table to Excel

    I need to pull data from a AS/400 table to Excel, and need to create a Micro for this. I am not aware of Excel Micros that much. Can I get some help?

    Aundhekar5 pointsBadges:
  • How do I get a macro to move between workbooks?

    I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5...). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks 3, 4, 5.......

    Bondsmith5 pointsBadges:
  • DBF file formatting from excel to dBASE file in openoffice

    I am trying to save an excel file opened in openoffice as a dbf file. However when I try to "saveas dbf" a text box opens that says "this document may contain formatting or content that cannot be saved in the dBASE file format". I was wondering if anyone can help me with how it should be formatted...

    kimannep10 pointsBadges:
  • Export Arabic data from AS/400 to Excel

    How can I export Arabic data from AS/400 to Excel?

    YEMEN50 pointsBadges:
  • Export Arabic data from AS/400 folder to Excel

    How to export data from AS/400 folder containing Arabic data in to Excel

    Jaipalsingh5 pointsBadges:
  • We are trying to make database of membership

    We're looking to create a database for our membership (particularly searching for an Excel sheet).

    jagdishchandrajoshi5 pointsBadges:
  • Correct password won’t open Excel doc in an attachment

    I have a password protected Excel document. I can open it with the password. When I send it as an attachment, I get a password is incorrect message.

    ronirothstein15 pointsBadges:
  • Establishing a connection from an IBM DB2 database

    I've been trying to establish a connection with an IBM DB2 database (from which I can extract data). Here are some of the details I have:Server NameData LibraryUsername/PasswordI've used both Microsoft Excel and SQL Server 2008 but neither way is working. Using Excel, this is what I tried: I have...

    ITKE436,000 pointsBadges:
  • Easy and faster way to pull data from a server using ODBC (VBA)

    I am looking for couple of options to pull data from AS/400-ODBC connection and manage data in Excel.

    xxsinghxx20 pointsBadges:
  • HTML, Excel, AS400

    can we post/store an excel file on the HTML site and link to the AS400 to pull data

    xxsinghxx20 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following