To Display Negative Dates

D

deepak

Hello !

Thanks to all you for helping out me in my previous problem. This i have a
problem with diplaying negative times,

Say A1= 10:30 (format is hh:mm) and B1 = 8:30 (format is hh:mm).
when C1=B1-A1, the value is displayed as ##### with notification negative
dates and times are displayed as ######.
Is there a way to display the negative time (for e.g. 8:30 - 10:30 = -2:00)

Thanks
 
D

Dave Peterson

If you switch to the 1904 date system:
Tools|Options|calculation tab (in xl2003 menus)

You can see negative times and dates.

Be aware that this setting is a workbook setting and can cause trouble when
copying dates from a different workbook.

And your existing dates in this workbook will now be 4 years and 1 day larger.

Saved from a previous post:

One way to add (or subtract) those four years back is to find an empty cell, put
1462 into that cell.

Copy that cell.

Select your range that contains the dates. Edit|PasteSpecial|click Add (or
subtract) (in theoperation box) and check values.

You may want to do it against a copy...just in case.

Most windows users use 1900 as the base date. Mac users (mostly??) use 1904 as
the base date.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top