Time difference

[Brento]

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

[Jed]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Roger Govier]

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote
> in
> message news:[email protected]...
>>
>> 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
>>
>
>