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

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

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

Rgds

David

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

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

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

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

May 30, 2009 | Microsoft Excel for PC

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.

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...

how to find current time?

Feb 19, 2009 | Microsoft Office Professional 2007 Full...

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...

try =round(x,2)-.01

Dec 01, 2008 | Microsoft Office 2003 Basic Edition...

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 ??

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

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.

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

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.

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

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.

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

Jan 28, 2016 | Microsoft Excel for PC

330 people viewed this question

Usually answered in minutes!

×