Thread
:
time to integer
View Single Post
#
8
Posted to microsoft.public.excel.programming
Alok
external usenet poster
Posts: 318
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?
Reply With Quote
Alok
View Public Profile
Find all posts by Alok