Timestamp
I imported a .csv file that has a column of timestamps in the following form:
15/04/20_01:13:46
In an adjacent column I extracted the "time" portion with the RIGHT function, 01:13:46.
I wanted to convert the "time" to a fraction by using Format, Cells, Number, but nothing happens.
If I actually type in the "time", 01:13:46, then the format is successful, and the cell value is 0.0512.
Is there a way of avoiding actually entering every "time" value in order to convert it to a fraction?
Hi there. try this:
=TEXT(RIGHT(A1,8),"?.????")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The RIGHT function returns a TEXT value even though it may look like a number (or time).
Try it like this...
A1: 15/04/20_01:13:46
=--RIGHT(A1,8)
The -- double unary minus will coerce the TEXT value into a NUMERIC value.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks