N
N
Nikita Melikhov2019-09-02 21:11:57
Google Sheets
Nikita Melikhov, 2019-09-02 21:11:57

Is it possible to do a time calculation in Google Sheets?

There are working time periods in the table, you need to calculate their sum. It is desirable also the cost of work at the cost of an hour.
For example, there are periods 12:00-14:00, 15:00-16:30, the sum is 3:30. If an hour, for example, is 100 rubles, then the total amount needed is 350 rubles.
Is it possible to do this in Google Docs or do I have to use separate software?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2019-09-02
@VeroLom

You can convert the time to numbers and simply multiply by rubles. Solution example, link

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question