user3090396
Reputation: 13
Total minutes from datetime value
How to get total time in minutes from datetime?
18/11/2013 07:31:04
The result should be: 451 min (it's 07*60 + 31).
Upvotes: 1
Views: 1014
Answers (1)
PA.
Reputation: 29339
Extract the hour and minute components of your date time with HOUR() and MINUTE() functions and combine them with this formula
=HOUR(A1)*60+MINUTE(A1)
Upvotes: 5
Related Questions
- Excel - Numbers of minutes to Time
- Excel adding up hours and minutes correctly
- Excel formula text to minutes
- Count the Total Minutes per interval based on raw data
- Calculate minutes in specific period
- Number of minutes in a time range - EXCEL
- Get minutes elapsed dynamically with Google spreadsheet formula
- Convert minutes and seconds to hours, minutes and seconds in Excel
- Excel Formula: Sum Column of Minutes, into summary in format DD:HH:MM
- formula to minutes and seconds down into total amount in seconds