Reply to thread

Message: [QUOTE="bj, post: 3710547"] It looks as though you actually have text and not a time value if you use<format><cells><number> and change to general, does the cell change? if not, it is text and you will have to convert it to a true time value. Which version of excel are you using? one way to generate a time value from separating the text into hours minutes and seconds hr =value(mid(date_time_text,find(":",date_time_tex)-2,2)) Min = value(mid(date_time_text,find(":",date_time_tex)+1,2)) Sec = value(left(right(date_time_text,4),2)) =time(hr,Min,Sec) now the equations you referenced should work [/QUOTE]