Solved

Excel XP Displaying time

Posted on 2002-07-05
2
261 Views
Last Modified: 2008-03-17
I am wanting to produce a productivity report within Excel XP.

I have everything ready but rather than returning a result of 25:10:10  (hh/mm/ss) it returns 01:01:10:10 (dd:hhmm:ss)

I have already tried customising the format to hhh:mm:ss but its ignores it.

Does anyone know the formatting to get a reult in hours: minutes: seconds please?
0
Comment
Question by:Wadski
2 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 100 total points
Comment Utility
Hi Wadski, a nice essay on time and date values
http://cpearson.com/excel/datetime.htm

:O)Bruintje

just as info in a hurry now.....
0
 
LVL 16

Author Comment

by:Wadski
Comment Utility
I found the answer via the MS website but as you have also provided the answer within that site I'll accept it.

its [hh]:mm:ss to display in hours
so  [mm].ss displaying in minutes
and [ss] displays in seconds


ta
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

How many times recently have you prepared a presentation or emailed a document to a client and you have found that they have older versions of MS Office and they can not open the file you have prepared.  Although most visitors to this site are exper…
This article will show you how to use shortcut menus in the Access run-time environment.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now