| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't graph data with Date Format with hours
I received a file with dates formatted using dd/mm/yy hh:mm and I want to
graph how many times a certain event occurs per date based on dd/mm/yy. I tried using "COUNTIF" to determine how many entries exist per day, but it does not find any match since the data contains hours and that is not relevant to the graph. I tried formatting the date field in the data using dd/mm/yy, but that only changes the way the date shows in the cell but not the actual format. How do I remove the hour:minute information? Thanks, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't graph data with Date Format with hours
It's maybe longwinded but if the dates are in column B, insert a column at
column C. If the first date and time is in cell B7, enter in cell C7 =Trunc(B7,0). Copy it to all the other cells, they will all have the time 00:00. You can format column C and hide column B. If you want to get rid of column B, insert a column at D, copy column C and paste values. Then you can delete B and C. "BRB" wrote: I received a file with dates formatted using dd/mm/yy hh:mm and I want to graph how many times a certain event occurs per date based on dd/mm/yy. I tried using "COUNTIF" to determine how many entries exist per day, but it does not find any match since the data contains hours and that is not relevant to the graph. I tried formatting the date field in the data using dd/mm/yy, but that only changes the way the date shows in the cell but not the actual format. How do I remove the hour:minute information? Thanks, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't graph data with Date Format with hours
Thanks, that worked.
"Highland Cow" wrote: It's maybe longwinded but if the dates are in column B, insert a column at column C. If the first date and time is in cell B7, enter in cell C7 =Trunc(B7,0). Copy it to all the other cells, they will all have the time 00:00. You can format column C and hide column B. If you want to get rid of column B, insert a column at D, copy column C and paste values. Then you can delete B and C. "BRB" wrote: I received a file with dates formatted using dd/mm/yy hh:mm and I want to graph how many times a certain event occurs per date based on dd/mm/yy. I tried using "COUNTIF" to determine how many entries exist per day, but it does not find any match since the data contains hours and that is not relevant to the graph. I tried formatting the date field in the data using dd/mm/yy, but that only changes the way the date shows in the cell but not the actual format. How do I remove the hour:minute information? Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| creaet a graph from the hours of a time field | Excel Discussion (Misc queries) | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| How do I format the data labels in my stacked bar graph? | Charts and Charting in Excel | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Linear Mode
