Using Excel 97 and am trying to make a simple time card that will calculate employees hours. I want to enter: Time in, Lunch out, Lunch in, Time Out--then have...

l2 = # of miles. q4 = bonus. How can I make q4 show the bonus based on the following: 10,000 miles = $50 15,000 miles = $75 20,000 miles = $100 ---

I'm trying to create a work time sheet. I have 3 columns=20 Start time (displays the time started - in hh:mm) Finish=20 Time (displays the time finished - in...

i have a workbook setup that have several pages in it (for a month) and some math where a cell that may not be filled in yet is a 0 value. so i am getting...

Hi All, Hope I find you well. I have a spreadsheet that has a number of cells that may or may not have data in them depending on curtain criteria. What I...

If you want to prevent a Userform from closing when the user clicks the x-button in the top right corner of the dialog....... I tried the suggested Macro and...

Hi there I'm trying to create a chart that will show weight loss progress but I'm having trouble. I need to display stone and Lbs in the y column I need it to...

This may be a stupid question, but is there any way to add your own colours into excel? --- Message posted from http://www.ExcelForum.com/

Hi All, I'm receiving an excel spreadsheet which has a 15 digit number in one of the columns. Some of the rows contain a number; some of the rows contain a...

I am trying to sort data by the answer in a column that is the result of a formula. How can I sort it by the result rather than the formula without hiding the...

Is is possible to apply different display and print formating criteria to a cell, range of cells or an entire worksheet? For example, when viewing cells, I...

Hi, I have an excel file that is used by multiple users. The file is linked to several other files and automatically updates itself when any of the othr files...

I need help... I am total newbie in Microsoft Visual Basic. I created UserForm in Excel, via Tools - Macro - Visual Basic Editor. Is it possible to create...

Hi, i`m newbi in Xcell. I want to calculate simple overtime If 5 Hours a day $20+ 2.50*B2 If between 5 to 7.30Hours then $25+3.00*B2 If more 7.30Hours and...

Greetings, My Excel worksheet is sorting numbers wrong. It's doing this: 94 92 9 9 9

Hello, I have a vertical bar chart (ie. a 'column' chart) with staff names along the bottom (x) axis and their hours up the vertical (y) axis. The staff names...

I want to be able to enter a part number in say "b2" and then the adjacent cell "c2" would fill in a description automatically and then in "d2" the list price...

Hi there trying to do a formula based on true/false output but I cant get round this Team A(B1) v(D1)Team B IF SUM(B1D1) say 1 - 0 {if true = 1 if false =...

Hi, I have "Excel XP" I would like to create a spread sheet, but I am unfamliar as to how to setup my data in a logical sense. Thanks, Holly