Unformatted Code

toNumber(replace(prop("Time Spent"), ":\\d*", ""))
toNumber(replace(prop("Time Spent"), "\\d*:", ""))

(
	toNumber(replace(prop("Time Spent"), "\\d*:", ""))
	+ 
	60 * toNumber(replace(prop("Time Spent"), ":\\d*", ""))
) 

join(
	":"
	, 
	format(
		floor(
			Total Time Spent (unformatted)
			/ 
			60
		)
	)
	, 
	if(Total Time Spent (unformatted) 
		% 
		60
		<
		10,
		"0",
		""
	)
	+
	format(
		Total Time Spent (unformatted) 
		% 
		60
	)
)
join(":",format(floor(prop("Total Time Spent (unformatted)")/60)),if(prop("Total Time Spent (unformatted)")%60<10,"0","")+format(prop("Total Time Spent (unformatted)")%60))

format(floor(Time Spent (number)/60))+":"+if(Time Spent (number)%60<10,"0"+format(prop("Time Spent (number)")%60),format(prop("Time Spent (number)")%60))

Properties

Tools

• Function Lookup
• RegEx Tester
• Error identifier
• Property Tracker
• Source Code for this template

Formatter

Builder

<aside> ❕ Use "/Create linked database" to bring your project in here, copy+paste your code, and test

</aside>

a

Finished?

<aside> ❕ When you're done, we recommend duplicating this page to create additional projects. All of the sub-pages, like Formatter, will be duplicated along with it. This way, things don't get too cluttered.

</aside>