View Full Version : Solved: userform label format
av8tordude
02-15-2011, 06:50 AM
In cell G2 is a time formated value (i.e. 23:24). I'm not sure why this code is not displaying this value in my userform label. Currently the label displays 0.974999. Can someone assist. thanks
TDay.Caption = Range("AG2")
av8tordude
02-15-2011, 06:54 AM
disregard...i figured it out
TDay.Caption = format(Range("AG2") ,"hh:mm")
IBihy
02-15-2011, 06:59 AM
Hello,
methinks, you should mark this thread as solved.
Isabella
av8tordude
02-15-2011, 07:28 AM
How do I get the label to display 26:52 instead of 02:52.
TDay = Format(Range("AG2"), "HH:MM")
Tinbendr
02-15-2011, 08:57 AM
try "[h]:mm" (http://www.cpearson.com/excel/datearith.htm#AddingTimes)
David
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.