Simple timer with pause/continue capability (single table design)

[Joe_Parisi]

Great formula! I was wondering if anyone figured out a way to display the Timer duration correctly while a the timer is running?

[Paul_Danyliuk]

You can wrap the Now() + ... part in Duration() formula. It will force Coda to treat the value as duration.

[Patricia_Hoffmann]

This looks very awesome!
Is there a way to convert the time in “Clock ins” and “Clock outs” to a different format, e.g. European time format (Day.Month.Year Hrs:Minutes:Seconds (no AM))

[Christiaan_Huizer]

hi @Patricia_Hoffmann

what about this:

Now().FormatDateTime(7,3)

Cheers, Christiaan

[Andy_Farquharson]

thanks for this, it is amazing!

I am trying to build on this and have created another button for “completed”. If the time is running, i would like this to stop the timer (and edit some other columns in the row, i.e. change the status to “completed”).

what is the formula I would need to write for the completed button to complete both tasks?

[joost_mineur]

You would need something like:

modifyrows(thisrow,thisrow.stoptime,now,thisrow.status,"stopped")

You disable the stop button if the stop time has already been entered.

Please make a sample doc, share it (or allow someone to ask for edit permission) and we can show in your sample doc how it is done.

[Andy_Farquharson]

here is a link

[John_Faig]

This is an amazing addition to one of my tables. When the timer is not running, the minutes and seconds are display nicely. See screenshot (A). While the timer is running, the timer does not show the progress in a nice format. See screenshot (B).

Is there a way to show this data in minutes and seconds? If not, is there a way to show dashes instead of a time?