Date Hour and Minute Format Question

[Wallie12]

Hello; I am using Crystal Reports 2008 and need to take in the following field a: Hours (value) b: Colon ) and c: Minutes (value) and combine them into one field.

I keep encountering an error when @hours + ':' + @minutes
Error message reads: "a number, currency amount, date, time or date-time is required here

Thanks

 

[lbass]

Replace the "+" with "&". Or, use:

totext({@hours},0,"")+":"+totext({@minutes},"00")

-LB

 

[Wallie12]

What if I wanted to turn this to actual Hours and Minutes.
What would the format look like?

 

[lbass]

Do you mean a time? You would use a formula (this assumes your hours and minutes are numbers):

time({@hours},{@minutes},0)

Then you could format it however you like.

-LB

 

[Wallie12]

Thanks