Need help converting text to numbers then translate time 1

[mustang83]

Hello, I'm relativley new to crystal and reporting. I'm sure I am over thinking this, but am not having any luck. Basically, I have a time value formatted as text, and times are stored as the number of seconds since midnight. I need to convert this text to a number, and then add to those seconds 00:00:00 (12:00am) to show the actual time of day.

This is what i have written, but all i get back is, "12:00:00AM"

//Looks for only fields with time
If {table.field} =10
//Convert text to number, number in seconds to time
then TimeValue (tonumber({table.field}))

Any thoughts would be greatly appreciated!

 

[IanWaterman]

If you are only interested in time and not the date you can use this

If {table.field1} =10
Time(dateadd("s", tonumber(table.field2), datetime(1900,01,01,0,0,0)))

Then in report designer format time as you want

Ian

 

[mustang83]

Thanks IanWaterman, I did what you suggested, however, my formula field is not returning anything? The value is, 41820.

Thoughts?

 

[lbass]

Ian's formula should work. It won't show anything if {table.field1} doesn't equal 10, so you should try inserting a maximum on the formul to see whether you have any records that meet this criterion.

-LB

 

[mustang83]

Thanks IanWaterman and lbass, you were correct, i actually mistyped the tabled and didn't even realize it this morning. Thanks again!