PDA

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