I have my time in hours:minutes:seconds
0:57:55
1:00:00
1:01:51
2:44:20
But I want to have it in decimals. For example the first row would be about 0.97 hours and the last row about 2.75 hours.
Have tried http://www.consultdmw.com/excel-time-conversion.htm but the formatting part didn't...
It's something I need to do in excel, in order to make it fit to GC. It's basically doing the same thing you showed me with "text to columns", but in reverse. Googled "columns to text", but didn't find anything.
That was exactly what I needed, thanks!
Now, I want to import them into google calendar. I have this: http://cl.ly/image/3l2h0s3t0q27 and I that's how it should be, but comma separated. See also: https://support.google.com/calendar/bin/answer.py?hl=en&topic=15286&answer=37118...
I would like to turn this: http://cl.ly/image/06300r2j3s0m a .csv file into this http://cl.ly/image/3v3H3q3D3j2t .xls file. Is that possible, and if yes: how? It's from my time tracking software.
Full files are here:
xls: http://cl.ly/2A171h451615
csv: http://cl.ly/0p2v0X0n2s1K
The most...