Ask Experts Questions for FREE Help !
Ask
    Legal12's Avatar
    Legal12 Posts: 1, Reputation: 1
    New Member
     
    #1

    Feb 3, 2009, 07:10 AM
    Excel 2007 Rounding of Time
    I am trying to prepare a timesheet in Excel 2007. It keeps rounding off the time. Does anyone know how to stop that?
    kurtwz's Avatar
    kurtwz Posts: 16, Reputation: 1
    New Member
     
    #2

    Mar 7, 2009, 02:35 PM

    Have you tried right-clicking in the cell in question, then selecting "Format Cells", and on the Number tab under "Type:" selecting a different way of displaying the data?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #3

    Mar 7, 2009, 04:58 PM

    Rounding the time how?

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How do you stop this time calculation formula from rounding [ 7 Answers ]

I did not make this formula, but found it on the internet. I am trying to figure out how to make it stop rounding. It is the "total" cell for the "time in" and "time out" on a timesheet. The cell is formatted as "time". I want it to return exact minutes worked and not round. Can someone please...

Excel Rounding off from REF sheet [ 12 Answers ]

My Excel is rounding off or up numbers when I multiply a cell in a sheet to a reference page in the workbook. (ie =(c38*'Bid Sheet'!k441) If I were to enter the number and not the reference cell it comes out correctly. This is simple math and not several decimals. 3*6 very often comes out as 19 as...

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Stop Excel from Rounding [ 1 Answers ]

I have created a Timesheet spreadsheet, in Excel, that calulates the amount of time between to manually entered times. This is the formula I am using =IF((OR(D8="";B8=""));0;IF((D8<B8);((D8-B8)*24)+24;(D8-B8)*24)) The formula works very well and does return the corrent amount of elapsed...

Excel rounding [ 1 Answers ]

ELATHAM How do I keep Excel from Rounding off. When it rounds off it makes my final totals wrong. My figures need to balance right to the penny. Thank you, Estrella


View more questions Search