Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only String Convert to Time 2

Status
Not open for further replies.

soushi01

Technical User
Dec 27, 2010
31
MY
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
 
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.
 
thanks Hilfy for the solution

its works :D

 
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
 



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]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top