| 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, |
| 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 | |||
Threaded Mode
