Can I convert hh:mm to mm in Excel

G

Guest

My question is two-fold. I need to calculate total time spent on a project
for my employees and the status reports provide the time spent on each
category to me in hh:mm format. I want to be able to enter that into a
worksheet, convert it to minutes only so that I can use the minutes for
totals calculations with the other projects. Then I want to be able to
convert the minutes back to hh:mm format in the final column. Can anyone
help?
 
B

Bob Phillips

Convert to minutes

=A1*24*60

To revert, divide by 1440 and format as time


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

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

Splitting dd/mm/yyyy hh:mm 2
convert number to hh:mm 2
Format duration in mm/dd hh:mm 3
Date and Time Conversion 3
Date format problems after csv import 2
how to convert total hours (HH:MM) into decimal number 1
Converting a number to hours and minutes 4
Hours to minutes jcs 5

Top