Question about Microsoft Excel for PC

1 Answer

Rounding Time in Excel 2007

I am preparing timesheets in Excel 2007. I need it to stop rounding time. Here is the formula: =IF((OR(C14="",C13="")),0,IF((C14

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers

Format the cells that contains times and net time worked as time format you using Enter the simple formula   =if(c14<=0,Int(0),(c14-c13))

Posted on Feb 05, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to make attendance sheet that entered in time and out time after complete the month, then give me report in total working hours.


You can find quite a few timesheets templates in Microsoft's site but most of them does not do the computation - I found one that does.called "Weekly Labor Expenditure Log" (see picture below). You can download it for free and adapt it for your purposes - let me know if you need help. I can forward it to you if you cannot find it

Rgds

David

davidleetw_0.jpg

Mar 03, 2011 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

REQUIRE EXCEL TIMESHEET Thursday to Wednesday. With DAY, date, start and end times with 1, 30 MIN meal break, total hours for the day (not to exceed 7), any time over 7 THEN GOES TO TIME IN LEIU COLLU


Here are already prepared template time sheets of which your description fits several.

http://office.microsoft.com/en-gb/templates/CT101172771033.aspx?av=ZXL000

May 30, 2009 | Microsoft Excel for PC

2 Answers

Writing a formula for a sumif problem


Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

1 Answer

Need to add additional field on employee timesheet .


There is a notes file that lets you add infor concerning the billing - it might be closed up to where you can only see the N, If you use the single Activity window you will see a nice large area to add info. These single activities will all show up on the weekly time sheet.

Jan 20, 2009 | Intuit QuickBooks Pro 2007 Full Version...

1 Answer

WRITING A LONG IF AND THEN FORMULA


The OS should not impact on the performance of Excel..
Have you upgraded excel from 2000 to 2007 ??

Power formulas are tricky to manage at the best of times.
The formulas that you have wrote for years may have been on the knife edge ... i.e. just less than 256 characters.
Have you exceeded this limit ??

Aug 06, 2008 | Microsoft Excel for PC

4 Answers

How many formulas we can use at a time in Excel


That depends on which version of Excel you are using.
Excel 2003 supports up to 65,335 formulas
Excel 2007 has no limit.
you can communicate between the worksheets which are contained by one workbook (one excel-file).
Communicating between files cannot be done with formula's.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Excel formula


the formulae for the surface area of round disc is
pi * r * r
where pi=3.14 and r =radious of disc= diametre/2 

for this 1st u have 2 calculate the radious of the disc that is
180/2=90mm
then convert it to  m by dividing 1000 ,so radious=90/1000=0.09 m
finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres
for 38 disc multiply 38 with the above area that is
0.025434 * 38=0.966492 sq metres

in excel 2007  u can do it more easily by going 2 formulas tab.
Under formla tab click on engineering formula and  then convert
here u can convert from mm to m
after converting use the above formula i just told u.

Feb 27, 2008 | Business & Productivity Software

2 Answers

Budgets in excel


Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Business & Productivity Software

Not finding what you are looking for?
Microsoft Excel for PC Logo

330 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...