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

expressions
(Miranda Lubarsky) #1

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 Pender) #2

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) #3

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 KULAÇOĞLU) #4

@Miranda_Lubarsky you can use the below expression:

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