how do i chart H:mm?? im having trouble

[kerry78]

Hi there! I have a problem charting some data....
Column A: I have values of 1 through 23 (these are cycles in m
business)
Column B: I have a different time value associated with coresspondin
cycle in format H:mm

Example:
cycle 1 took 29:55 (29hours and 55minutes)

I need to display as a graph/chart for tomorrow am!


Y axis are my cycles
X axis should be intervals of time in increments of 5 hours

Is it not charting properly because time is displayed H:mm- does i
need to be decimal format? Also, the data i am grabbing is from cell
that have formulas attached, so does that cause a problem....?
Thanks everybody!
PS: I am not at work now-so cant attach file for review, but will sen
to anyone willing to help in the a

 

[Tushar Mehta]

You should also check the responses to all the other discussions in the
same newsgroup that you've started on the same subject.
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions