Only String Convert to Time 2

[soushi01]

Hi,

Im Newbie of WebI


how to let string 235959 convert to time 23:59:59

i tried try write this formula --> FormatNumber([time];"##:##:##")

thanks

regards,
s1

 

[hilfy]

Try this:

Left([dimension]; 2) + ":" + Substr([dimension]; 3;2) + ":" + right([dimension]; 2)

This assumes that the string will always be 6 characters long - two for hour, two for minutes, two for seconds with a leading zero for each if it is less than 10 (like 010101 for 01:01:01)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[soushi01]

thanks Hilfy for the solution

its works

 

[bta1322]

Hi - new user to WebI

Trying to use mod function in BO
=mod([Available for delivery];1)
Keep getting error. The Avaialble for delivery" column contains, date and time, eg 09/02/11 17:57:12

Any help appriciated

Brian

 

[SkipVought]

bta1322,

it is not polite to hijack someone elses thread with a totally different topic.

Please post your question in a NEW THREAD.

Explain WHAT you are trying to accomplish, not just how to make MOD work.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]