bar chart measuring minutes (not clock time)

**kmfdm515** · 11-11-2010, 01:18 PM

Hey guys,

I am trying to format a bar chart to measure the monthly call duration. Data in excel looks like this:

4:20
10:34
8:21

etc. It has to keep this minutes:seconds look for the chart data labels...not be converted to minutes in decimal form.

Which cell format will allow both the chart data labels and the Y axis labels to display that way? I've tried time formats and custom formats and nothing seems to work. They all either seem to want to convert it to an actual timestamp (11/1/10 4:20 AM) or change it to minutes in decimal form.

Thanks...

**6StringJazzer** · 11-12-2010, 12:54 PM

I didn't have any problem with this at all; see attachment built in Excel 2007. Please do the following:

Update your profile to indicate what version of Excel you are using

Attach a sample file illustrating your problem

**kmfdm515** · 11-17-2010, 10:22 AM

thanks for the reply. sorry, excel 2007 here. i didn't save the chart since i couldn't get it to work. it was a very basic chart, like the one you posted.

the chart you posted seems to work with that formatting - except when a value exceeds 24 minutes, which causes the axis to go from 23:00 to 0:00 again. is there any way to have that display correctly as 25:00, 26:00, etc?

**Andy Pope** · 11-17-2010, 12:46 PM

That's 24 hours not minutes.

Use a custom number format
[h]:mm

**kmfdm515** · 11-17-2010, 01:06 PM

ah, that works...thanks!

**keith@wrc** · 09-06-2013, 04:42 PM

Hello,

I work at a hospital and I am trying to track how long it takes for a single housekeeper to clean a room (in minutes). In other words I need the graph or chart for a sixty minute time period. Then I have get the chart or graph to show in minutes how long they spent cleaning the room.

I hope this makes sense.
Help!

Thanks

**6StringJazzer** · 09-06-2013, 05:42 PM

Welcome to the Forum keith@wrc!

Please take the time to review the small number of rules for the forum. One of the rules is not to post a new question in someone else's thread. Your question is not related to the original post, and people are reviewing the thread to address the original post. Starting your own thread will get a better audience for your specific question, and keep other threads cleaner. Adding a question in an existing thread should be only about the original problem or one of the posted solutions.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.