# Notion Answers

Help between Notion users

It's free & easy

### Get answers

Answers, votes & comments

### Vote and select answers

Receive points, vote and give the solution

2votes

# How can I calculate minutes to add total hours (or minutes) in a formula to add totals?

Hello. I would like to keep track of my time per project. I have a date field that has a start and end time. I can get the total minutes using:

``format(dateBetween(end(prop("Clock-In Clock-out")), start(prop("Clock-In Clock-out")), "hours")) + "hr " + format(dateBetween(end(prop("Clock-In Clock-out")), start(prop("Clock-In Clock-out")), "minutes") % 60) + "min"``

However, this gives me x minutes in the column that can not be added as a summary. How can I convert the value to a numeric value (minutes is OK, Hours and Minutes will be better).

Thank you...

MK

## 1 Answer

0vote

avidnotionuser Points1430

Create another property formula and use function ToNumber(prop()) to convert to a numeric value. The in ( ) is the name of the property you used to calculate the minutes.

However, I would recommend watching this YouTube video to solve this problem: Notion Task Management: Calculate How Much Time To Spend On A Task

## Please log in or register to answer this question.

### Extend Notion Powers

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!