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).
Extract the hour and minute components of your date time with HOUR() and MINUTE() functions and combine them with this formula
HOUR()
MINUTE()
=HOUR(A1)*60+MINUTE(A1)
Extract the hour and minute components of your date time with
HOUR()
andMINUTE()
functions and combine them with this formula