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

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!

0 3 303
3 REPLIES 3

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

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)

@Miranda_Lubarsky you can use the below expression:

=CONCATENATE(HOUR([Duration Column]), โ€œ:โ€, MINUTE([Duration Column]))

Top Labels in this Space