Need to convert the beloe format

Microsoft Excel 2003 (full product)
April 25, 2010 at 15:25:50
Specs: Windows XP
Hi i have the time format as Wed Dec 31
18:59:59 EST 1969
i need this to be in hh:mm:ss

See More: Need to convert the beloe format

Report •


#1
April 25, 2010 at 15:57:02
Hi,

Right-click the cell.
Select Format Cells...
Select the Number Tab
From the list select Custom (at the bottom)
In the box labeled 'Type:' enter: hh:mm:ss
(no quotes required)
Hit OK

Regards
PS As anyone who responds is a volunteer, it would be customary to ask for help, rather than just saying what you need.


Report •

#2
April 25, 2010 at 16:19:14
i tried that to but its not working.
It was the time which i copied from Tivoli

it needs to denote the estimated duration


Report •

#3
April 25, 2010 at 19:27:06
As Humar noted, it is customary to ask for help, not just tell us what you need.

It is also customary to say Thanks for any help received, even if it doesn't work exactly as you would like. After you have acknowledged the help offered, feel free to explain what doesn't work and what you are looking for in a little more detail.

It would be helpful if you provided an example of some input data and the desired output - after you say please and thank you.


Report •
Related Solutions


Ask Question