![]() |
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)? |
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)? |
All times are GMT +1. The time now is 02:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com