Thread: time to integer
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Alok Alok is offline
external usenet poster
 
Posts: 318
Default time to integer

Try this formula
=CONCATENATE(INT(B1*24),INT((B1*24-INT(B1*24))*60),ROUND((B1*24*60-INT(B1*24*60))*60*1000,0))
Assuming that the time is in B1

"Piers 2k" wrote:

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