Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
Hi All, I am trying to display the difference in time in a minus state but all i get is ######, eg 36:00:00 - 48:00:00 = -12:00:00 but what i get is #######, please can any one help. thanks Brent -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=500549 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
To get negative time, use 1904 date system.
Select Tools, Options, click on calculation tab & put a tick in 1904 date system. Hope this helps. Jed "Brento" wrote in message ... Hi All, I am trying to display the difference in time in a minus state but all i get is ######, eg 36:00:00 - 48:00:00 = -12:00:00 but what i get is #######, please can any one help. thanks Brent -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=500549 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time difference
Hi
Note that this will throw any other dates you have entered on the sheet already, out by 4 years and 1 day because of the difference in the base reference date. If this is a problem for you, stick with 1900 date system but use =MOD(A1-B1,1) where A1 = 36:00:00 and B1 holds 48:00:00 -- Regards Roger Govier "Jed" wrote in message ... To get negative time, use 1904 date system. Select Tools, Options, click on calculation tab & put a tick in 1904 date system. Hope this helps. Jed "Brento" wrote in message ... Hi All, I am trying to display the difference in time in a minus state but all i get is ######, eg 36:00:00 - 48:00:00 = -12:00:00 but what i get is #######, please can any one help. thanks Brent -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=500549 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
Time Difference | Excel Worksheet Functions | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |