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"
wrote in message
...
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