get rid of seconds in display

[jmfox2]

trying to create field that looks like: 1500(12.5) to represent start shift time and the duration of the shift.

I have shiftstartdate shiftstarttime, shiftenddate, shiftendtime that are datetime fields.

hour(shiftstarttime) &"("& datediff('h',shiftstarttime,shiftendtime)

getting 1500.00(12.00) want 1500(12.5)

any ideas would be greatly appreciated.

 

[lbass]

Try:

totext(hour(shiftstarttime)*100,0,"") +"("+ totext(datediff('n',shiftstarttime,shiftendtime)/60,1)

I added *100 to the hour portion as I couldn't see how you could use the hour function and have it return 1500 (for 3PM) without that.

-LB