[users] oocalc - 5h 3m 10s to time format

2007-12-09 Thread Rafal
Hello, I have time informations in format like "5h 3m 10s" or "4m 10s" (if zero hours) how to use it as a time, in example convert it into normal 4:10 format using some regexp? -- LimCore.com - outsourcing - To unsubscribe, e

Re: [users] oocalc - 5h 3m 10s to time format

2007-12-08 Thread S Perry
Evidently, as was pointed out to me off-list, I misconstrued the question, not realizing he was referring to the results of time calculations. Here's a solution from September: Date: Mon, 17 Sep 2007 19:34:48 +0530 From: "Sudheer Satyanarayana" <[EMAIL PROTECTED]> Add to Address Book

Re: [users] oocalc - 5h 3m 10s to time format

2007-12-08 Thread Brian Barker
At 17:24 08/12/2007 +0100, Rafal Noname wrote: I have time informations in format like "5h 3m 10s" or "4m 10s" (if zero hours) how to use it as a time, in example convert it into normal 4:10 format using some regexp? Here's a suggestion: o First put the hours figures in explicitly where th

Re: [users] oocalc - 5h 3m 10s to time format

2007-12-08 Thread S Perry
Simply right click on the number containing the time element, select Format Cells > Number > Time, then select the format of your choosing. If you don't find the format you want, you can create one based on the format code shown in the box for that purpose. HTH Rafal <[EMAIL PROTECTED]

[users] oocalc - 5h 3m 10s to time format

2007-12-08 Thread Rafal
Hello, I have time informations in format like "5h 3m 10s" or "4m 10s" (if zero hours) how to use it as a time, in example convert it into normal 4:10 format using some regexp? -- LimCore.com - outsourcing - To unsubscribe, e-