# EXCEL time formula

Hello fellows,

I have this data on cell A1  258189107.3  where this is a tenth of a second, I need it in A2 to convert that data in Hours:Minutes:Seconds  , I saw in "format cell properties" an option for this but no so much in the actual formula...,is this possible?

thanks for your taking a look
LVL 3
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
In A2 use this formula:

=MOD(A1,1)

Format that cell h:mm:ss

Flyster

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Commented:
If you want just the .3, you can use =MOD(A1,INT(A1))
Author Commented:
So I actually would like the one that could do the whole cell entirely regardless of fractions or whole numbers,  I just happen to pick that number but there are few other columns I need to do...the. I will copy paste the rest
Commented:
The number you listed is not a valid date value. That number won't occur until the year 708783! If you have valid date values, you can format the cell to show just the time.
Finance AnalystCommented:
Assuming that the number 258189107.3 represents a number of seconds with the .3 being the tenth of a second, divide that number by 86400 and format as [hh]:mm:ss to convert to time.

86400 is the number of seconds in one day, this is made up of 24(hours) x60(minutes) x60(seconds).

Using [hh] will show all hours rather than resetting to zero each time it goes over 24.

Or without the custom format:

=TEXT(A1/86400,"[hh]:mm:ss")
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.