A. 60 hours CLICK HERE TO SELECT THIS OPTION B. 600 hours CLICK HERE TO SELECT THIS OPTION C. 6 hours CLICK HERE TO SELECT THIS OPTION D. 3.6 hours 360 minutes =
Answers
Sorry...
But the question is incomplete.
So I won't be able to help.
Step-by-step explanation:
3 years ago
Converting hours and minutes (hh:mm) to minutes in an Excel spreadsheet is actually quite simple, once you know what to do. But I had to do quite a bit of trial and error and Googling to get it to work.
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. This is where I got caught — I didn’t have the correct formatting applied to the cells. Once I got that right, it all worked.
Here’s how…
Enter elapsed times in hours and minutes (using the format hh:mm) in Column B. (Yes, those non-stop flights to/from Sydney to Dallas Fort Worth are killers!)
Set the format for this column to Custom > h:mm. (To format the column, select the column header, right-click on it, select Format Cells, select Custom on the Number tab, then select h:mm from the list of types. Click OK.)