ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Universal time (https://www.excelbanter.com/excel-programming/396500-universal-time.html)

Joseph Felcon

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)?

Tom Ogilvy

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