Converting decimals to time formula needed

gamerxavier

Distinguished
Apr 4, 2011
58
0
18,580
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.
 

gamerxavier

Distinguished
Apr 4, 2011
58
0
18,580
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
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
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