Time Calculation

[Carl Smith]

How can I get the result "10:30am - 6:00pm" when using 2 time fields "Start Time" & "End Time"?

I'm sure that the answer must be simple but I can't think of it!

[aaa]

result=End_Time-Start_Time in secunds.

[Carl Smith]

Thanks for your reply. I mean to show the answer as text (e.g from 10:30am until 6.00pm) formatted with a hyphen not as an mathematical equation.

[aaa]

GetAsText ( Start ) & "-" & GetAsText ( End ) Calculation result must be text

[comment]

See also this.