Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #109535
| From | isabelle <i@v.invalid> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Convert date/time to serial number and compare serial numbers |
| Date | 2016-11-04 14:44 -0400 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <nvikuo$d9d$1@gioia.aioe.org> (permalink) |
| References | <98547fda-134a-4767-b2e8-1b9ea37e2d6e@googlegroups.com> <0856f823-dbba-4d40-b59e-ccdb09e32b95@googlegroups.com> |
Le 2016-11-04 à 13:57, GARYWC a écrit :
> How can I convert serial number 42361.53146 to a date and time?
Range("B1").NumberFormat = "yyyy/mm/dd hh:mm:ss"
isabelle
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-03 15:35 -0700
Re: Convert date/time to serial number and compare serial numbers "Auric__" <not.my.real@email.address> - 2016-11-04 04:19 +0000
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-03 22:05 -0700
Re: Convert date/time to serial number and compare serial numbers "Peter T" <askformy@gmail.com> - 2016-11-04 08:20 +0000
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 07:59 -0700
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 11:51 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 12:10 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 11:54 -0400
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 10:57 -0700
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 14:44 -0400
Re: Convert date/time to serial number and compare serial numbers isabelle <i@v.invalid> - 2016-11-04 15:45 -0400
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 12:15 -0700
Re: Convert date/time to serial number and compare serial numbers GARYWC <gcotterl@earthlink.net> - 2016-11-04 14:53 -0700
csiph-web