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>
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=.............?
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
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
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 .
Excellent! This is exaclty what I was looking for.
Awesome! So glad it helped, Gerardo!
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>
Another great tutorial, thanks!
THANK YOU THIS IS GREAT STUFF!!
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=.............?
Thanks, Dan. Great tip
Thanks! :)
Your video is one of the reasons I pay monthly internet fee and buy the apple equipment .. do they share the profit with you?
Cool! Thanks :)
hi....where have you declared "myVar"
hi dear
In this method, how to diff between start time and end time?
Very good. Thanks!
Hi Ewerton, you're very welcome! Thanks for the comments!
Thanks!!!
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.
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
Great!
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
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 .