Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 01-04-2009
Member
 
Join Date: Apr 2009
Posts: 2
Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second?

***

Excel's Time Capture ("Insert a static date or time") Function:
Is it possible to have it capture times down to the second?


Greetings!

I have just discovered the "Insert a static date or time" function (details below) in Excel and am equally exited and frustrated, due to the fact that I cannot get it to capture the time down to the seconds place. It only goes as far as minutes.

Is there a way to customize or otherwise adjust something in either Windows XP or in Excel to allow the capture of 'up-to-the-second' times from within excel using this command?


---
Insert a static date or time
1. On a worksheet, select the cell into which you want to insert the current date or time.
2. Do one of the following:
-- To insert the current date, press CTRL+; (semi-colon).
-- To insert the current time, press CTRL+SHIFT+; (semi-colon).
-- To insert the current date and time, press CTRL+; (semi-colon), then press SPACE, and then press CTRL+SHIFT+; (semi-colon).
---

Thanks,

Rob



***
***
Reply With Quote
  #2  
Old 01-04-2009
Member
 
Join Date: May 2008
Posts: 3,313
Re: Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second?

First, it's important to remember that Excel keeps dates informatios as day fractions. Therefor, to show the value it first needs to be converted like this:


Divide el value in seconds (16548) in (60 s / min * 60 min/hr * 24 hr/day) to get


=16548/(24*60*60)
or
=A1/(24*60*60)


This result can then be formatted as hh:mm:ss
Reply With Quote
  #3  
Old 10-04-2009
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second?

Microsoft Excel has the time feature in which you can adjust or customize the way you want to display the time.....you can follow the settings already mentioned by Raine...... it must hopefully work.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second?"
Thread Thread Starter Forum Replies Last Post
What excel function do I use to search for the number "4" for a date range of 1/1/2012 - 1/31/2012? Looks&Mustardseeds Windows Software 1 09-03-2012 11:58 PM
Panasonic PV-GS31 Camcoder, How to capture movie with Date/time hardik_shah Portable Devices 1 02-12-2011 06:57 PM
At the time of updating my computer the following error occur "WindowsUpdate_8007010B" "WindowsUpdate_dt000". Barraq Operating Systems 5 05-04-2011 08:26 AM
Where is "Capture from video device" Option in Windows 7 Movie Maker Ritvikk Windows Software 5 19-03-2011 10:55 AM
Date and Time control panel missing "Internet Time" life036 Windows Server Help 1 30-01-2008 06:19 PM


All times are GMT +5.5. The time now is 08:56 AM.