View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
babs babs is offline
external usenet poster
 
Posts: 38
Default Displaying negative time

Hi everyone,
first time on here so hope you can help me.

I use Excel (2003) for recording employee time / flexi hours. This is
allowed to go into a negative but I can't seem to display this. The formula
calculates fine and when the time is positive is shown in the time format (ie
15:30 etc) but when it is negative I just get #### which usually means the
column needs widening but this doesn't make any difference.
Any ideas anyone?
Thanks

--
Babs - Leicester UK