Thank you for writing.
Following your scenario I have created a sample project for you. The grid in the project has three columns Start Time
, End Time
. The Start Time and End Time columns are DateTime
columns and the value in the duration column is Decimal
. The value of the Duration column is the difference between the start time and end time. The the duration value is displayed in minutes. The summary row displays the total duration in hours.
Now for the first question, regardless of first and second columns visibility the values of the duration column will remain. For example you can hide the second column like this:
As to the second question I use the following expression to calculate the duration in minutes:
If you want to display the duration in hours use expression like this:
Also you will notice that there is no mistake in summary row when the duration is calculated.
I hope this helps. Should you have any other questions do not hesitate to ask.
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WINFORMS.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>