excel convert minutes to hh:mm

Is there a way I can use a time entered in a cell in the format hh:mm:ss and convert it into a decimal of minutes? Basically an associatate logs on to thier phone (call center) and the phone data is represented in an excel book where I strip the data I need into my own workbook. Method 1: Simple Multiplication.

Converting HH:MM to Minutes in Excel Date: 06/25/2003 at 10:28:31 From: Saurabh Mehta Subject: Converting Hours:Minutes (HH:MM) to Minutes in Excel Hi, I want to know if there is any easy method (i.e. Convertir un format hh:mm:ss, rapidement et facilement, en secondes. In Excel, if you just want the hours from hh:mm:ss, the formula is: =hour(cell where the data is located) In Excel, if you just want the minutes from hh:mm:ss the formula is: By using our site, you acknowledge that you have read and understand our Super User is a question and answer site for computer enthusiasts and power users. Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Aug 13, 2003 #1 I have a problem. To convert hours and minutes to minutes, you have to multiple the hh:mm value by 1440 (which is 24 [number of hours in the day] multiplied by 60 [number of minutes in an hour]), AND make sure you set the formatting correctly for the both the hh:mm cells and the resulting minute cells.
Active 3 years, 2 months ago. Related Articles: How to use the Stone to lbs weight in Excel. Convert minutes to hh:mm:sec in excel. Convert minutes to hh:mm:sec in excel. 0. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. Thread starter front-line; Start date Sep 15, 2010 ... Board Regular. You must log in or register to reply here.

I have tried using the 'Time' function but can only get it to work if I enter each of the three parts in separate columns. Excel: convert unusual minute format into numbers.

Thread starter jboles; Start date Aug 13, 2003; J. jboles New Member. Joined Sep 10, 2009 Messages 79.

Juan, Thank you, your solution worked perfectly. By clicking “Post Your Answer”, you agree to our To subscribe to this RSS feed, copy and paste this URL into your RSS reader. I am developing an excel report for display of monthly phone log results. Converting HH:MM to Minutes in Excel Date: 06/25/2003 at 10:28:31 From: Saurabh Mehta Subject: Converting Hours:Minutes (HH:MM) to Minutes in Excel Hi, I want to know if there is any easy method (i.e.

7:30, (seven hours, thirty minutes), into a decimal hour value in Excel. in A2 14. Thanks Noel

Explore more articles on conversion here. Sep 15, 2010 #1 Hi guys, I would like to know how can I convert minutes into HH:MM format. I am trying to convert hh:mm:ss into minutes. Ask Question Asked 3 years, 2 months ago. Sep 15, 2010 #1 Hi guys, I would like to know how can I convert minutes into HH:MM format. Any ideas?? Convert Time to Minutes in Excel.

For example, h:mm or h\.mm or any other way you might want. Convert hh:mm:ss time format to seconds / minutes / hours with Kutools for Excel. How to convert times, e.g. We will help you. By using our site, you acknowledge that you have read and understand our The simplest way to convert a time to a number of minutes is to multiply the time by 1440, which is equal to 24*60 (the number of minutes in one day):
To convert hours and minutes to minutes, you have to multiple the hh:mm value by 1440 (which is 24 [number of hours in the day] multiplied by 60 [number of minutes in an hour]), AND make sure you set the formatting correctly for the both the hh:mm cells and the resulting minute cells. any formula or a macro) available for converting Hours:Minutes (HH:MM) to Minutes in Excel. The data is represented in hh:mm:ss.