using dates and time in formulas

[changetires]

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

[Bob Phillips]

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