|
|
|
|
#1
09-20-2017, 03:35 AM
|
|||
|
|||
To get time to register it, use Now function, which returns a date AND time. In Excel, a date is integer (the number of days at 01.01.1900 00:00:00), and time is decimal part of day. I.e. 1 hour equals 1/24, 1 minute equals 1/(24*60) etc. P.e. I read current time in excel, using NOW() worksheet function, and in General format it was 42998.5644840278 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to open text (or csv) file from Excel VBA without Excel messing up with dates | ArviLaanemets | Excel Programming | 1 | 06-13-2017 11:31 PM |
 Need Excel to recognize week numbers based on specific dates
|
Ktyler | Excel | 5 | 02-06-2017 11:08 AM |
|
Excel: Dates in a chart
|
Dyeaton | Excel | 2 | 10-19-2016 05:03 AM |
| Dates from Excel into Outlook | MrAdamRe | Outlook | 4 | 03-17-2015 06:10 AM |
|
Excel is changing dates.
|
laqa | Excel | 5 | 11-06-2014 07:26 PM |
Windows 8 
Office 2016
Hybrid Mode