Convert string to HH:MM

[fragglemoo]

I'm using CR2008 and need to convert a string field e.g. 38.2 to hh:mm (38:02).

I've looked at

http://www.tek-tips.com/faqs.cfm?fid=3543

as per a previous post but this doesn't seem to help.

Thanks.

 

[Madawc]

If it's always in that format, you could do it as

split({your.field},".")[1] & ":" 
& split({your.field},".")[2]

If the data varies it would be more complex, check ubound. Also the formula I gave would give you 38:2. You might need to edit a bit more, something like

ToText(@second_bit, "00")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

A simpler method would be to convert it to a time, then format it.

ToText((Time({your.string)), "HH:mm"

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Madawc]

Sorry, that should be

ToText((Time({your.string)), "HH:mm")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Try this variation on Madawc's solution:

if ubound(split({your.field},".")) > 0 then
(
split({your.field},".")[1] & ":"
& totext(val(split({your.field},".")[2]),"00")
) else
{your.field}

-LB

 

[fragglemoo]

Thanks