Question about Microsoft Excel for PC

# 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

• Level 1:

An expert who has achieved level 1.

• Contributor

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

## 1 Suggested Answer

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

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

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

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

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

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

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

### Rounding off numbers

check the standard tool bar, increase decimal places/decrease decimal places tool will solve your problem.

Nov 04, 2008 | Computers & Internet

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

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

### 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 | Computers & Internet

### Budgets in excel

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 | Computers & Internet

#### Related Topics:

334 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert