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

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

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:53 +0200
Organization A noiseless patient Spider
Message-ID <qmgd2f$3cf$1@dont-email.me> (permalink)
References (1 earlier) <qmg18d$kd3$1@dont-email.me> <7ad01b74-6d16-4730-8a8e-f77403ba0813@googlegroups.com> <qmgb5t$nat$1@dont-email.me> <6fbfb13a-4f9a-4ff9-b9e1-6992074d9a45@googlegroups.com> <qmgcrl$22g$1@dont-email.me>

Show all headers | View raw

Hi,

Am Wed, 25 Sep 2019 20:49:25 +0200 schrieb Claus Busch:

> s = "10:04 PM"
> t = TimeValue(s)
> s = Format(Hour(t), "00") & Format(Minute(t), "00")

or easier:

s = "10:04 PM"
s = Format(s, "hhmm")


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