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

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

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

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

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

## Open Questions:

#### Related Topics:

330 people viewed this question

Level 3 Expert

Level 3 Expert