using dates and time in formulas
 

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

using dates and time in formulas
 

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