0

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

Jerry
  • 70,495
  • 13
  • 100
  • 144
user3090396
  • 3
  • 1

1 Answers1

4

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)
PA.
  • 28,486
  • 9
  • 71
  • 95
  • Caveat: don't format with TEXT() because, as a side effect, it prevents to use the result as a number in some other formula. Instead, change the Cell Format. – PA. Dec 11 '13 at 10:11