K kingston via AccessMonster.com Nov 10, 2006 #2 HH:MM:SS MM minutes = MM/60 hours SS seconds = SS/3600 hours So HH:MM:SS = (HH + MM/60 + SS/3600) hours Functions that you may want to use are Hour(), Minute(), Second().
HH:MM:SS MM minutes = MM/60 hours SS seconds = SS/3600 hours So HH:MM:SS = (HH + MM/60 + SS/3600) hours Functions that you may want to use are Hour(), Minute(), Second().
G Guest Nov 10, 2006 #3 Found it, 5 min after posting... sorry for bugging you. (Time Serial) * 24 = (Decimal Time)
