How to take time in Google Spreadsheet?

R

Roman2019-05-28 09:34:15

Google Sheets

Roman, 2019-05-28 09:34:15

Hello.
We have cells " beginning and ending " they contain the format " hour : minute ", you need to understand how much time has been spent in the third cell?

How to write a formula that will subtract time?
Thanks

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

V

Valery, 2019-05-28
@RGBPlus

=I6-H6

Similar questions

I

Ivan Ivashin2017-07-09 19:36:58

Google Sendmail problem can't formulate email? 1Reply

P

pomozov2021-06-03 10:21:52

How to make dependent cells with checkboxes available for changing their state? 1Reply

E

Eremey Ikashev2020-01-01 08:31:13

How to transfer data from google forms to google sheets? 1Reply

A

AndreyTT2020-01-13 20:54:59

How to replace in google spreadsheets (google spreadsheet) in a range of cells relative links with absolute ones? 3Reply

S

SHT2020-01-14 09:10:23

How to add rows manually to a sheet where QUERY is already output from another sheet? 1Reply

Didn't find what you were looking for?

Ask your question