LinkBack URL
About LinkBacks
In the previous post, I made a mistake.
I need to know, how to format text (70:30) become 2.9375
In the previous post, I made a mistake.
I need to know, how to format text (70:30) become 2.9375
Last edited by marreco; 04-02-2012 at 06:48 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
What post are you referring to?
This.
Turns hours in serial number
Why don't you just post this in the original thread?Originally Posted by marreco
It would be like me saying,"Hey guys", my previous post I meant to say "X=1", sorry"
Nobody would know what I was talking about.
Note that C15 is the format text.
I need to turn this time (C15), in decimal, then D15 = 2.9375
Last edited by marreco; 04-01-2012 at 09:49 PM.
I believe this should do it.
=(MID(C15,1,LEN(C15)-3))/24+(RIGHT(C15,2)/1440)
Format the cell as general after.
Hi.
Perfect!!
Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks