Can I convert hh:mm to mm in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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)
 
Back
Top