Hi Jo
Excel will not show negative time when using the standard date system. That
is why you are getting the '####'s.

You could choose ToolsOptionsCalculation and select the 1904 date system,
and this will allow negative time, but beware, if you are carrying out other
date calculations as this will throw those calculations out.

Another alternative is to convert the times to decimal time.
Excel stores times as fractions of a day, so you have to multiply each value
by 24.

=(A1*24)-(B1*24) will show a result of -2.45 hours (note not 2 hours 45
mins, but 2.45 hours).
You need to format the cell with the formula as General.


Regards

Roger Govier


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