| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not rounding when I do not want to display 0's
I have an Excel timesheet that I don't want to display the 0's in the total
hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
You could apply conditional formatting to the total hours column, such
that if the cell contains zero then use a white foreground colour (on a white backgound) so that the cell appears empty. You can then apply a decimal format for numbers that are not zero. Hope this helps. Pete On Feb 5, 12:13*am, Melissa_payroll wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. *I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. *Is there a way I can have both? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
Try
[h]:mm;;"";@ -- Jacob "Melissa_payroll" wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
I put in the time from 8:30-15:45 and instead of it giving me 7.25 it gave me
174:00. Any other suggestions? "Jacob Skaria" wrote: Try [h]:mm;;"";@ -- Jacob "Melissa_payroll" wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
That sounds like a great idea, however, how do you do conditional formatting?
:) "Pete_UK" wrote: You could apply conditional formatting to the total hours column, such that if the cell contains zero then use a white foreground colour (on a white backgound) so that the cell appears empty. You can then apply a decimal format for numbers that are not zero. Hope this helps. Pete On Feb 5, 12:13 am, Melissa_payroll wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? . |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
Have you tried Excel help?
You can access from Help on menu in 2003 or by clicking on the ? in 2007 Gord Dibben MS Excel MVP On Fri, 5 Feb 2010 12:49:01 -0800, Melissa_payroll wrote: That sounds like a great idea, however, how do you do conditional formatting? :) "Pete_UK" wrote: You could apply conditional formatting to the total hours column, such that if the cell contains zero then use a white foreground colour (on a white backgound) so that the cell appears empty. You can then apply a decimal format for numbers that are not zero. Hope this helps. Pete On Feb 5, 12:13 am, Melissa_payroll wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not rounding when I do not want to display 0's
If you multiplied the time by 24 to get an answer in decimal hours, then you
don't want to format as hours and minutes. You should format it as General or Number. If you want to se it as an Excel time in hours and minutes, then don't multiply it by 24. -- David Biddulph Melissa_payroll wrote: I put in the time from 8:30-15:45 and instead of it giving me 7.25 it gave me 174:00. Any other suggestions? "Jacob Skaria" wrote: Try [h]:mm;;"";@ -- Jacob "Melissa_payroll" wrote: I have an Excel timesheet that I don't want to display the 0's in the total hours column when there isn't any time for that day. I did the 0;-0;;@ to make the 0's go away, but now the total hours round to a whole number when I need it to read a dismal. Is there a way I can have both? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Have Excel display an error rather than rounding # to fit column | Setting up and Configuration of Excel | |||
Linear Mode
