What's the most convenient way(s) to input one or more times into spreadsheet cells?
1:2:3 <- works =TIME(1;2;3) <- works well, but is awfully inconvenient ="1:2:3" <- doesn't work (it's just a string) ="1:2:3"+0 <- seems to work in every situation I've tried it so far =1:2:3 <- doesn't work (shows "Err:502") =1:2:3+1:2:3 <- doesn't work (it did in OOo2 but now shows "Err:502") So, 1:2:3 seems to be OK if there's only one time, but if you, say, need to add 5,5 minutes to it you can't just append +0:5:30 but will also have to add quotes and stuff, so 1:2:3 becomes ="1:2:3"+"0:5:30". I'm currently using ="1:2:3"+0 because if I want to add a time I can simply replace the 0 with that time without having to insert anything else anywhere. However, I haven't seen this documented anywhere (well, actually I haven't seen any of these documented anywhere) and it seems kinda hackish, so I wouldn't be surprised if it broke at some point. Are there other even remotely convenient ways? - Marcus --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
