inserting time in Excel

Microsoft Office excel 2007 home & stude...
June 20, 2010 at 00:40:06
Specs: Windows XP, 1.8/1gig
hi, hope this is in the right area I do not have a clue about computers etc, but I want to insert the time in excel, which I know how to do that, but can I change the time from hours and minutes to hours minutes seconds and even parts of seconds even to seconds would be a help, can somebody tell me in easy terms please
thanking you

See More: inserting time in Excel

June 20, 2010 at 04:43:06

You can't change the time stored by Excel, but what you can do is format the cell containing an Excel time to show Hours, minutes, seconds and 100ths of a second.

Select the cell.
Right-click Format Cells...
Select Number and create the following Custom format:


Report •

June 20, 2010 at 05:07:38
hi , thank you for your time, but that wh en I just did it, just puts zeros in the seconds and 100ths seconds not numbers as in the actual time,
example 21:58:00.00
there was a lady some years ago sent me a detailed description how to make a macro, I have no idea now, that i could just use a specific key ( of my choice ) to put the time down, think that was in word
I have looked on here on this site and the internet I see the formulas, but have no idea of what to do with them, so thought this would be a simple way, but I do not know if it is, but thank you for your time

Report •

June 20, 2010 at 05:56:33

How did you enter the time?

If you enter =NOW() in cell A1 and format it as "hh:mm:ss.00" you will see the seconds and hundredths.

Click f9 to update the time.

As to the macro, perhaps if you said what you wanted it to achieve, someone could help you.

If you have found 'formulas' that do what you want, but don't know how to use them, why not include them in your post.


Report •

Related Solutions

August 1, 2010 at 19:21:40
hi, how can i have an automatic time on a specified cell every time i input in other cell.

i will input a number in cell G5 and there will be a time exactly the same of my computer in the cell F5.


Report •

August 1, 2010 at 19:38:11
Please post your question in a new thread.

Your question is not a continuation of this thread, which is actually about formatting time.

Your question is different and should be in it's own thread. Once you post it in a new thread, with a different subject line. I will delete it from this thread.


Office Forum Moderator

Report •

Ask Question