Converting decimals to time formula needed

gamerxavier

Distinguished
Apr 4, 2011
58
0
18,580
0
trying to find a formula on converting decimals to time. I'm making a spreadsheet for a game >..> and i am trying to manage something.
say i have this.. 7.72=days I need a formula for google docs to convert that into the actual time.
 

PhilFrisbie

Distinguished
Apr 22, 2006
666
0
19,310
53
Here is the way to do it by hand, and you can translate it:

0.72 * 24 hours per day = 17.28 = 5PM and 0.28 of an hour
0.28 * 60 = 16.8 = 16 minutes and 0.8 of a minute
0.8 * 60 = 48 seconds

So, 0.72 of a day = 5:16:48PM

 

gamerxavier

Distinguished
Apr 4, 2011
58
0
18,580
0
well I guess I said it wrong ._.What I meant was I want the decimals to come out like this days:hours:minutes:seconds. Also, what would be interesting if I can get a way to take that time and add it to current time to get the finish time. so say its 1/30/2013 5:32:19pm right now. I get 6.34 days. take that time and get the completion time. How would I do this? I don't know very many formulas for google docs.
 

BobtheHelper

Honorable
Oct 22, 2013
2
0
10,510
0
Hi, I don't know if you have solved your issue by now, but I guess not since PhilFrisbie's comments don't really help.

I just had the same issue with a time which was 3.89 in field C4
So I used: =FIND(".",C4) that returns me the position of the . which is 2
=Left(C4,D4-1) which returns me 3
=right(C4,D4) which returns me 89
Just multiply 89*0.6 and you have minutes

I tried to do it by using the function =split() but couldn't make it to work on a calculated field.
 

BobtheHelper

Honorable
Oct 22, 2013
2
0
10,510
0
Oops sorry

For =right(C4,D4) it's not correct. you need to round with
=ROUNDUP(C4,2) so you have 2 decimals
And then you do =right(C4,2) so it returns you the decimals.

Then you can even be fancy and concatenate
=CONCATENATE(F4,$G$3,H4)
in F4 i have 3
in G3 I have H
in H4 i have 54 // (83*0.6)
so it returns me 3h54

 
Thread starter Similar threads Forum Replies Date
M Apps General Discussion 5
M Apps General Discussion 3
P Apps General Discussion 1
A Apps General Discussion 2
The Paladin Apps General Discussion 4
P Apps General Discussion 2
N Apps General Discussion 1
T Apps General Discussion 31
D Apps General Discussion 1
S Apps General Discussion 1
W Apps General Discussion 1
T Apps General Discussion 1
G Apps General Discussion 1
M Apps General Discussion 2
Z Apps General Discussion 5
velocityg4 Apps General Discussion 8
D Apps General Discussion 3
Reggod Apps General Discussion 1
G Apps General Discussion 1
A Apps General Discussion 13

ASK THE COMMUNITY