Duration value in a start expression

AppSheet AppSheet Q&A
, ,
1

Hello, I am using this start expression in an excel template <<Start:SELECT(Daily Report 2[Unique_ID], [Job Number] = [_THISROW-1].[Job Number])>><<[Job Number]>>

There is a Column called <<[Total Travel Time]>> this is a DURATION column in appsheet, and it displays in appsheet and in the source data table as HH:MM:SS. This is good.

The problem is Wwhen the data is displayed in the template with the above expression it displays in DAYS ( ie 12 hrs displays as 0.500).

How can I fix this to display in hours in the template?

2

The display of date/time/duration values in both AppSheet and your Excel file depends on the regional settings of your device, while the value itself is non human readable.

Convert the column to a text using the TEXT() command to explicitly force the desired format.

3 Likes
3

Thanks!

1 Like