Welcome to Tech Support Forum home to more then 136,000 problems solved. Issues have included: Spyware, Malware, Virus Issues, Windows, Microsoft, Linux, Networking, Security, Hardware, and Gaming Getting your problem solved is as easy as:
1. Registering for a free account
2. Asking your question
3. Receiving an answer

Registered members:
* Get free support
* Communicate privately with other members (PM).
* Removal of this message
* See fewer ads.
* And much more..

 





Want to know how to post a question? click here Having problems with spyware and pop-ups? First Steps
Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support
User Name
Password
Site Map Register Donate Rules Blogs Mark Forums Read

Microsoft Office support MS Office support forum

Reply
 
Thread Tools
Old 07-18-2008, 07:05 PM   #1 (permalink)
Registered User
 
pjolegario's Avatar
 
Join Date: Jul 2008
Location: Davao City, Philippines
Posts: 1
OS: windows xp SP2


how to insert active time on excel sheet

a pleasant day to all

i'm a new guy here and saw how helpful you guys with each other

can you help me/teach me how to insert active time on excel sheet?
i really appreciate this, thanks.
pjolegario is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Bookmark on Thread SoupReddit!
Reply With Quote
Old 07-18-2008, 07:23 PM   #2 (permalink)
Registered User
 
Join Date: May 2008
Location: Baltimore, Maryland
Posts: 97
OS: Windows XP SP3


Re: how to insert active time on excel sheet

A pleasant day to you, too.

A quick way to place the current time in a cell is to use:
Ctrl-Shift-;
The time will not automatically update with that method.

If you want the time to be updated each time the spreadsheet is calculated, use the formula:
=NOW()
and format the cell as h:mm AM/PM.
David M58 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Bookmark on Thread SoupReddit!
Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -7. The time now is 06:14 AM.



Copyright 2001 - 2008, Tech Support Forum

Search Engine Friendly URLs by vBSEO

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82