Not rounding when I do not want to display 0's

  • Thread starter Thread starter Melissa_payroll
  • Start date Start date
M

Melissa_payroll

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?
 
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
 
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 said:
Try

[h]:mm;;"";@

--
Jacob


Melissa_payroll said:
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?
Click to expand...
Click to expand...
 
That sounds like a great idea, however, how do you do conditional formatting?
:)
 
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
 
Back
Top