Excel VBA Format Textbox Hours and Minutes for Start Time and End Time

Подписаться 98 тыс.

Просмотров 36 тыс.

50% 1

📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
Learn how to manipulate textboxes with hours and minutes time formatting. BONUS - at the end, learn how to make it either 24 hour (military time) OR civilian time (am and pm)! Fun stuff!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...

Опубликовано:

16 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@gerardogalavizjimenez6615 6 лет назад

Excellent! This is exaclty what I was looking for.

@ExcelVbaIsFun 6 лет назад

Awesome! So glad it helped, Gerardo!

@sarahargrave4591 4 года назад

This is very helpful. I have an issue though. I want users to be able to enter time as "1:30" and get "1:30 PM" not 1:30 AM. No need for my users to have to know military time to enter the time the call came in. How do I make this happen with the code you provided in the video>

@darrengodkin 7 лет назад

Another great tutorial, thanks!

@selinulupnar3875 3 года назад

THANK YOU THIS IS GREAT STUFF!!

@KnowEverythin 5 лет назад

i have 3 text box, i.e A, B, C. pls provide the formula when i want to output in textbox 3(c} when i want to time difference between textbox1and text box2. suppose Text box 1 = 22:00(10 pm) textbox2= 01:00 {1 am) Textbox3=.............?

@grosgros4115 3 года назад

hi....where have you declared "myVar"

@JanKowalski-hk5cg 3 года назад

Your video is one of the reasons I pay monthly internet fee and buy the apple equipment .. do they share the profit with you?

@rezasaberi7264 2 года назад

hi dear In this method, how to diff between start time and end time?

@eCabinetstipsandtricks 7 лет назад

Thanks, Dan. Great tip

@ExcelVbaIsFun 7 лет назад

Thanks! :)

@deadlock107 7 лет назад

Cool! Thanks :)

@erickboczar678 4 года назад

Thanks!!!

@mrsk8145 5 лет назад

myVar=Empty. Therefore not showing the same value as "Me.tbStart" am pretty much stuck there and cannot go further please assist. Many thanks in advance Kay

@ewertonemmanuel 6 лет назад

Very good. Thanks!

@ExcelVbaIsFun 6 лет назад

Hi Ewerton, you're very welcome! Thanks for the comments!

@krn14242 7 лет назад

Thanks Daniel. Why did you not have success with FORMAT? Weird stuff happen? I use both TEXT and FORMAT and have not seen much difference yet anyway.

@ExcelVbaIsFun 7 лет назад

Hi krn14242, it may have been a fluke, but I couldn't get the hh:mm stuff to do what I wanted, but the same syntax with the worksheetfunction worked better. I think these were coded slightly differently by Microsoft, but I'm not sure all the subtleties. Thanks, my friend! Dan

@vbaexpertonline8032 5 лет назад

Great!

@KnowEverythin 5 лет назад

Sir, if i text box2 input time is less then input textbox1, then give error msg in excel... exm textbox1= 00:20, textbox2=23:30... then give error msg .