| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Universal time
Using VBA under Excel, I need to get time (e.g.: Now function) expressed as
UTC rather than in PC local time. Does anyone know how to acquire UTC time directly (as with .NET DateTime.UtcNow)? Failing that, does anyone know how to acquire the System clock parameter to convert PC local time to UTC time (using DateAdd)? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Universal time
http://www.cpearson.com/excel/LocalAndGMTTimes.htm
-- Regards, Tom Ogilvy "Joseph Felcon" wrote: Using VBA under Excel, I need to get time (e.g.: Now function) expressed as UTC rather than in PC local time. Does anyone know how to acquire UTC time directly (as with .NET DateTime.UtcNow)? Failing that, does anyone know how to acquire the System clock parameter to convert PC local time to UTC time (using DateAdd)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| universal worksheet name | Excel Programming | |||
| Universal formulas for any given row | New Users to Excel | |||
| universal code | Excel Programming | |||
| Universal procedure for changes | Excel Programming | |||
| Make A Universal Time Converter | New Users to Excel | |||
Hybrid Mode
