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
ivan rosaAsked:
Who is Participating?
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.

FlysterCommented:
In A2 use this formula:

=MOD(A1,1)

Format that cell h:mm:ss

Flyster
0

Experts Exchange Solution brought to you by

Your issues matter to us.

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

Start your 7-day free trial
FlysterCommented:
If you want just the .3, you can use =MOD(A1,INT(A1))
0
ivan rosaAuthor 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
0
FlysterCommented:
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.
0
Rob HensonFinance 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")
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.