Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111140

Re: VBA time conversion

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: VBA time conversion
Date 2019-09-25 20:20 +0200
Organization A noiseless patient Spider
Message-ID <qmgb5t$nat$1@dont-email.me> (permalink)
References <80d5be5a-c945-48e8-8dd7-e08aa6a2cfe5@googlegroups.com> <qmg18d$kd3$1@dont-email.me> <7ad01b74-6d16-4730-8a8e-f77403ba0813@googlegroups.com>

Show all headers | View raw

Hi,

Am Wed, 25 Sep 2019 11:06:07 -0700 (PDT) schrieb RG III:

> The data is not stored in a cell. I was just trying to find a method to convert time strings stored in variables.

try:

s = "10:20 PM"
t = TimeValue(s)
s = Hour(t) & Minute(t)


Regards
Claus B.
-- 
Windows10
Office 2016

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-25 02:44 -0700
  Re: VBA time conversion "Peter T" <askmy@email.com> - 2019-09-25 16:31 +0100
    Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-25 11:06 -0700
      Re: VBA time conversion Claus Busch <claus_busch@t-online.de> - 2019-09-25 20:20 +0200
        Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-25 11:37 -0700
          Re: VBA time conversion Claus Busch <claus_busch@t-online.de> - 2019-09-25 20:49 +0200
            Re: VBA time conversion Claus Busch <claus_busch@t-online.de> - 2019-09-25 20:53 +0200
              Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-25 12:02 -0700
                Re: VBA time conversion Claus Busch <claus_busch@t-online.de> - 2019-09-25 21:21 +0200
                Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-25 13:15 -0700
                Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-26 00:37 -0700
                Re: VBA time conversion Claus Busch <claus_busch@t-online.de> - 2019-09-26 10:10 +0200
                Re: VBA time conversion RG III <mob.rrr.3@gmail.com> - 2019-09-26 01:42 -0700

csiph-web