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.
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.
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.