| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creaet a graph from the hours of a time field
Advice please
I have a column in a sheet with the time - date and time but formatted to show the time I have a number of tickets against each time €“ the time the tickets were bought there can be many records all for different dates I would like to generate a simple graph showing how many tickets were purchased in each hour period or even each 4 hour period Can anyone please point me in the right direction please I have looked the chart wizard and pivot tables but I cannot figure out how to group and count the ticket numbers in to the time slots? I hope this makes sense thanks Michael -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200803/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
| How do add time/hours to get answer in hours if Ans24 | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
| How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Threaded Mode
