Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Convert hours:minutes:seconds into total minutes in excel [closed]

Tags:

How can I convert hours:minutes:seconds into total minutes in Excel?

like image 372
Nikhil Surendran Avatar asked Jan 22 '13 09:01

Nikhil Surendran

2 Answers

enter image description here

Just use the formula

=A8*60*24

like image 195
Moosli Avatar answered Sep 19 '22 15:09

Moosli

Just use the formula 

120 = (HOUR(A8)*3600+MINUTE(A8)*60+SECOND(A8))/60
like image 29
Nilesh patel Avatar answered Sep 21 '22 15:09

Nilesh patel
Sign in to Comment

Related questions

Convert object's properties and values to array of key value pairs
Returning a tuple from a function using uniform initialization syntax
How do I wrap multiline Ruby arguments in HAML?
Get last character of a string from a variable
Get the most recent file in a directory, Node.js
ostringstream gives me Implicit instantiation error
jquery to loop through table rows and cells, where checkob is checked, concatenate
Is using a vector of boolean values slower than a dynamic bitset?
Access a global variable from any app controller
Using sql function generate_series() in redshift
Exclude characters from a character class
How can I suppress parameter expansion in a here-doc in Bash?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!