I have a column with 'time of the day' data. It is a survey data of people going to work and their timing of leaving from home. It has values like 7.30, 8.20, 10.0, 1.25 etc. What these values actually mean is 7:30AM, 8:20AM, 10:00AM, 1:25PM.
How do I convert these values to time format?
Hello and welcome to the forum.
If those "times" are text values, try this:
=TIME(INT(A2+0),MOD(A2+0,1)*100,0)
If those "times" are numeric values, try this:
=TIME(INT(A2),MOD(A2,1)*100,0)
... or:
=(INT(A1)+MOD(A1,1)/0.6)/24
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
Or use this
Formula:
Please Login or Register to view this content.
Format as Custom, h:mm AM/PM
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Yea... Dollarde... remembering that one doesn't come naturally to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks