Excel compute time
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?
95 pts.
One Cell to calc inputs from mult workbooks
Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.
Have a summary sheet and want it to calculate information from a standard daily form (seperate workbook) that gets saved as the days date, daily. Want summary sheet cell to continuously calc what is inputed on daily form even after it is saved as something else.
Range of one cell backcolor in excell 2003
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...
Dear Sir Madame I am doing a function in Excel 2003 that takes three cells as range data-type. the function all it does is to see if two of the cells equal to the third one. if yes I want to color the background as green Can anyone reply to my request? Thanks in advance p.s. I am using the RTD...
Automatic transfer of Data from AS/400 DDS Described file to Excel spreadsheet
Hi, Is there an easy way to automatically "refresh" the data in an excel spreadsheet from an AS/400 DDS Described Data file? I'd like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. ...
Hi, Is there an easy way to automatically "refresh" the data in an excel spreadsheet from an AS/400 DDS Described Data file? I'd like the data to be collected whenever someone opens the spreadsheet. I can already get the data using a transfer request, but I have to start the request manually. ...
SSIS only 255 rows uploaded ?
Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any...
Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any...
Pivot Tables - I need more than rudimentary calculations
Does anyone know of a site that exchanges calculation information for Pivot Tables???
Does anyone know of a site that exchanges calculation information for Pivot Tables???
formatting excel using lotusscript
I would like to know how can I draw borders on a cell in excel with lotusscript? I've goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?
I would like to know how can I draw borders on a cell in excel with lotusscript? I've goggled for sites that give excel exporting tutorial but none provides a detailed explanation. Any suggestions?
Lotus Notes Import
I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS Range name: this...
I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS Range name: this...
Vista and Office 2007
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.
Error while running a form
Hi when running a form i am getting an error and my output is not been created and when i debug i gives me a clause that excel is running in the back end but there was no excel running
Hi when running a form i am getting an error and my output is not been created and when i debug i gives me a clause that excel is running in the back end but there was no excel running
How do I activate specific worksheets when importing from Excel
I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs. Currently I am using this method and it directs to the last saved(active) sheet. Set xlsSheet = xlsWorkBook.ActiveSheet I tired this...
I have a script in Lotus Notes that imports data from a excel spreadsheet. I want to be able to always activate a specfic sheet every time the script runs. Currently I am using this method and it directs to the last saved(active) sheet. Set xlsSheet = xlsWorkBook.ActiveSheet I tired this...
How do I run my report on excel worksheet?
I have a alv report and i need to run on my excel sheet ,How do I go about?
I have a alv report and i need to run on my excel sheet ,How do I go about?
