Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time
I have a column that has numbers that specify time, however, they are only
listed as (8, 60, 125, etc). I would like them to represent hours/minutes, but can't get it to work using the 'format cells'. After I get these to change in to hours/minutes I would like to make a chart from the source data that shows intervals (<5 minutes, 5-9 minutes...). I have time columns in a number of tabs (each tab represents a different month) on the same worksheet and would like to make one chart. After that, I would like to take all the tickets that took over 60 minutes to finish and put them into a different tab so i can further break them down. This is turnging into one big mess. Please advise. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
Hot key for time? | Excel Worksheet Functions | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Entering Times | Excel Discussion (Misc queries) |