Thread: time to integer
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kassie kassie is offline
external usenet poster
 
Posts: 268
Default time to integer

He is working in Minutes, Seconds and Thousandths of seconds. At the end of
the day, he wants to concatenate the minutes - say 20, the seconds - say 12,
and the thousandths, say 254, to then get 2012254. He does not want to
change the times in any way, but to get a numeric value based on the
concatenation.

"Piers 2k" wrote:

What's the 3-digit number on the end? Is this the score?