Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional date/time format
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.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional date/time format
"hmm" wrote in message
... 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.) 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Military Time Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Format for negative time | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |