Total minutes from datetime value

983 views Asked by At

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).

1

There are 1 answers

1
PA. On BEST ANSWER

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)