Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

Can you use the Time format without the AM/PM?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Glenn Mulno - 23 Sep 2005 15:51 GMT
OK - I am trying to track data that keeps track of how long an event took.
For example - a typical data point would be customer hold times on the
phone.  I would like to track that the Highest Hold time of the day was in
this format:

00:01:26

Which should represent that the hold time was 1 minute and 26 seconds.

No matter how I have tried to format this data, Excel is trying to interpret
this as the time of the day, not a length of time.  So for Excel, it think
what I have entered is 12:01:26 AM.  When in actuality - this could have
occurred at 9:00 AM or some other time of day.

I can get it to display without the AM/PM but Excel still interprets this as
actual time and not length of time.

That would be fine except I wish to then be able to graph this time over a
few quarters. and Excel is not doing what I want then.

Is there some way to force Excel to understand that this entry is not the
actual time but a length of time?

Thanks,

Signature

Glenn

ptp24 - 23 Sep 2005 16:42 GMT
Glen:

If you choose the "text" option under format cells, it will only
display what you type in the cell. That will fix your AM/PM problem.

Let me know if this worked out your graphing problem too.

Pete

Signature

ptp24

Bob Phillips - 23 Sep 2005 17:06 GMT
It shouldn't make any difference. Format it as you want it, then graph it,
Excel stores time as a fraction of one day.

Signature

HTH

Bob Phillips

> OK - I am trying to track data that keeps track of how long an event took.
> For example - a typical data point would be customer hold times on the
[quoted text clipped - 20 lines]
>
> Thanks,
Roger Govier - 23 Sep 2005 17:10 GMT
Hi Glenn

Format Cells>Number>Custom   hh:mm

If you are summing these times, then the cell that holds the summation
formula will need to be formatted as [hh]:mm to allow the value to cycle
past 24 hours.

Regards

Roger Govier

> OK - I am trying to track data that keeps track of how long an event took.
> For example - a typical data point would be customer hold times on the
[quoted text clipped - 20 lines]
>
> Thanks,
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.