Hey guys! If I have an appformula expression ...

[Miranda_Lubarsk]

Hey guys! If I have an appformula expression which adds up the duration or some columns, is there any way for me to get rid of the seconds digits? Not seeing a place to control this.

Thanks!

[Mary_Jane_Pende]

Hi Miranda,

If you go to this support item you will see Tony Fader’s advisory for do this.

plus.google.com - IS THERE A WAY IN APPSHEETS TO FORMAT DURATIONS TO JUST hh:mm INSTEAD OF hh:m… IS THERE A WAY IN APPSHEETS TO FORMAT DURATIONS TO JUST hh:mm INSTEAD OF hh:m… plus.google.com

[Steven_Coile]

Not that I can find. You could use a separate, virtual column to strip the seconds from the computed duration:

=concatenate(left([duration], (len([duration]) - 6)), right([duration], 3)

[Levent_KULACOGL]

@Miranda_Lubarsky you can use the below expression:

=CONCATENATE(HOUR([Duration Column]), “:”, MINUTE([Duration Column]))