Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
How can I get around this:
"Negative times or dates are displayed as ####"? The calc is 20:18 - 23:45 Answer should b -3:27 tia -- Traa Dy Liooar Jock |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
Switch to the 1904 date system, ToolsOptionsCalculation, and check the
1904 date system checkbox. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jock" wrote in message ... How can I get around this: "Negative times or dates are displayed as ####"? The calc is 20:18 - 23:45 Answer should b -3:27 tia -- Traa Dy Liooar Jock |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
Assuming all cells formatted as [hh]:mm
Tools|options|Calculation Check 1904 date system Mike "Jock" wrote: How can I get around this: "Negative times or dates are displayed as ####"? The calc is 20:18 - 23:45 Answer should b -3:27 tia -- Traa Dy Liooar Jock |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
Is that a global setting or restricted to the workbook that I'm currently in?
-- Traa Dy Liooar Jock "Bob Phillips" wrote: Switch to the 1904 date system, ToolsOptionsCalculation, and check the 1904 date system checkbox. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jock" wrote in message ... How can I get around this: "Negative times or dates are displayed as ####"? The calc is 20:18 - 23:45 Answer should b -3:27 tia -- Traa Dy Liooar Jock |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
currrent workbook
"Jock" wrote: Is that a global setting or restricted to the workbook that I'm currently in? -- Traa Dy Liooar Jock "Bob Phillips" wrote: Switch to the 1904 date system, ToolsOptionsCalculation, and check the 1904 date system checkbox. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jock" wrote in message ... How can I get around this: "Negative times or dates are displayed as ####"? The calc is 20:18 - 23:45 Answer should b -3:27 tia -- Traa Dy Liooar Jock |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More time please...
You will find the setting under "Workbook Options" in ToolsOptionsCalculation
tab. So..............it is a workbook setting. Gord Dibben MS Excel MVP On Tue, 14 Aug 2007 09:30:01 -0700, Jock wrote: Is that a global setting or restricted to the workbook that I'm currently in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |