convert hours and minutes to minutes

G

Guest

I need to convert hours and minutes 1:45 (One Hour and 45 Minutes) into total
minutes... Any ideas
 
C

Chip Pearson

Use a formula like the following:

=A1*24*60

Format the cell as General or Number.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting minutes to tenths 2
Quarter Hour time conversions for timesheet 2
excel formula 1
I have 3053 minutes and I want to convert to hours and minutes 2
Converting hours into minutes 2
Format 8.3568 into: 8 years, 4 months, 8 days, 10 hours, 45 minute 7
Concerting total minutes to hours and minutes 7
How do I get total amount of hours in time format 3

Top