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

[@sarahargrave4591]

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>

[@grosgros4115]

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

[@KnowEverythin]

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=.............?

[@rezasaberi7264]

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

[@mrsk8145]

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

[@KnowEverythin]

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 .

[@JanKowalski-hk5cg]

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

[@krn14242]

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]

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

[@gerardogalavizjimenez6615]

Excellent! This is exaclty what I was looking for.

[@ExcelVbaIsFun]

Awesome! So glad it helped, Gerardo!

[@darrengodkin]

Another great tutorial, thanks!

[@selinulupnar3875]

THANK YOU THIS IS GREAT STUFF!!

[@eCabinetstipsandtricks]

Thanks, Dan. Great tip

[@ExcelVbaIsFun]

Thanks! :)

[@ewertonemmanuel]

Very good. Thanks!

[@ExcelVbaIsFun]

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

[@deadlock107]

Cool! Thanks :)

[@erickboczar678]

Thanks!!!

[@excelvbaexpertonline8032]

Great!