Can I convert hh:mm to mm in Excel
 

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?

Can I convert hh:mm to mm in Excel
 

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)

"Armymanofwar" wrote in message
...
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?