Format VB command

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

x = "2:01"

debug.print format (x,"0# ##")

I get 00 00

Shouldn't this return

02 01 ??

Thanks - Kirk
 
Hi,

x is representing time so use

format("2:01","hh mm")

Cheers
Andy
 
Kirk,

What is "2:01" a time?

if so

Debug.Print Format(x, "hh:mm")
returns 02:01

Debug.Print Format(x, "hh mm")
returns 02 01

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to create charts 1
Calculating occupational sick pay entitlement 0
fixed column data 1
VB script line graph 1
Time averaging raw data 3
Access Running Balance in Access 1
Receiving valid Multicast address failed on mini port driver 0
Calculating chnages in time 1

Back
Top