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]> wrote:
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-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
