S
S
Scalletta2022-03-28 14:48:27
Google Sheets
Scalletta, 2022-03-28 14:48:27

How to convert duration to minutes in google spreadsheet?

There are several columns with duration (the sum of time =Sum(B47:B49) and the format "Duration")
I want to know the percentage of each column.
62419dd0a7b18263906221.png
The main problem is to calculate the amount of minutes, so that later on this amount to calculate the percentage.
I tried to break it into Hour and Minute, but if the hours are more than 23 it does not work.

I'm trying to make formulas because manually counting is not an option. time is added every day and there may be more columns.

Example:
62419f28ab594720482255.png

Here is the same problem, as soon as Duration (A3) becomes 24:00:00 then Hour(A3) becomes zero:
6241a00e01f93332181147.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2022-03-28
@Scalletta

Because time is essentially a number too, just divide a certain time by the amount of time, and the share will be calculated.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question