Varunraj Belgaonkar
Reputation: 45
How to find elapsed time between two datetime values
I working in google sheets. I have already formatted datetime value and separated them in two columns. Now I want to find the time elapsed between these two dates?
date1 : 04/26/21 8:25:00 AM
date2 : 05/01/21 4:46:00 PM
What formula to use in google sheets?
Upvotes: 0
Views: 97
Answers (1)
JohnA
Reputation: 1107
All you need to do is substract the two dates
=H34-G34
Then set the format to Number/Duration of the cell with the formula
Upvotes: 2
Related Questions
- Better way to calculate time between two datetimes in Google Sheets?
- Google sheet time difference calculation
- Finding the difference in time in excel
- Excel | Calculate the time difference
- Calculate time between two time stamps with a gap in between in Excel
- Difference Between 2 Dates and Times in Excel
- Finding the number of days and time between 2 dates/times in excel
- How to calculate the time between two periods of time?
- How to calculate time difference between two cells in Excel
- Finding time elapsed from two times in yyyy-mm-dd hh:mm format