No, the format is irrelevant, the calculations will use the underlying
values.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"changetires" <changetires.2a0xno_1151349902.4281@excelforum-nospam.com>
wrote in message
news:changetires.2a0xno_1151349902.4281@excelforum-nospam.com...
>
> I am substracting dates and times in 2 cells then using the sums to
> calculate percentages of loss and or gain. Do all my formula cells
> need to be in the same date and time format?
>
> ED
>
>
> --
> changetires
> ------------------------------------------------------------------------
> changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
> View this thread: http://www.excelforum.com/showthread...hreadid=555737
>