Jo,

The # signs indicate that the column in which the cell with your result
displays is formatted too narrowly to show the whole value. Usually you have
a value in the cell immediately to the right which needs to display as well.

The solution is simply to resize the column to show your entire result. At
that point you may wish to reformat the result such that it use less width.

Good luck,
Joe

"Jo" wrote:

I am currently working on a timesheet and its urgent that I can sort
something out today. we work on a flexi basis this lady has a contracted
hours of 14:48 hours a work and she worked 12.21 hours last week but it
doesn't seem to like to deduct time I think it should be -2.27 (2 hours 27
minutes) but it just comes up ############# I don't think it likes the
minutes????? It works ok if she has worked over her contracted hours. Can
anyone help me please. Thanks