Conditional date/time format

  • Thread starter Thread starter hmm
  • Start date Start date
H

hmm

My data includes a column list of date/times. I want to show only the time
if the date is the same as the one above, and show both date and time only
for new dates. Is there any way to do it? (I am using Excel 2000, but
upgrade to 2007 is pending.)
 
hmm said:
My data includes a column list of date/times. I want to show only the
time
if the date is the same as the one above, and show both date and time only
for new dates. Is there any way to do it? (I am using Excel 2000, but
upgrade to 2007 is pending.)
Click to expand...

I don't know about 2007. For older versions, you could do this in two
columns. For example, for dates in column A starting at A1, put this formula
in B2 and copy down as far as necessary:
=IF(INT(A2)=INT(A1),"",A2)
In B1 you could put just =A1.
Then format column column B with a date format of your choice. This will
show the date only where it differs from that above.

For times, you could just format column A with a time format of your choice.
(Formatting just changes what is shown, not what is contained in the cell).

Of course, you could swap the columns over if you want the date shown to the
left of the time.
 
Back
Top