Hi!

Can you post an example?

Unless you're using the 1904 date system you can't display a negative time
format like -6:15. There are some convoluted "work arounds" but they can
cause more grief if you need to do downstream calculations.

Using the 1904 date system can cause problems with any other dates that you
may already have in your file. Your dates would be off by 1462 days.

You can display negative time in decimal format if that will suffice.

-6:15 would be -6.25

A1 = 5:00 PM
B1 = 11:15 PM

=(A1-B1)*24

Returns -6.25

Biff

"kllebou" <kllebou@discussions.microsoft.com> wrote in message
news:D09B85F7-5219-44F7-BD46-0D005CEAFC1E@microsoft.com...
>I have two values which represent lapsed times. When I subtract one from
>the
> other it sometimes results in a negative value. This is valid for the
> spreadsheet. I can display the result in minutes only but not in hours and
> minutes. In other words I want the result to look like -6:15. Can anyone
> assist