View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Converting hours to minutes

Multiply by 1440 (24 hours per day by 60 minutes per hour)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"KSGORE" wrote in
message ...

I am new to excel and I need help. I need to convert hours 01:10 to
minutes 70. For one column A. What is the formula and how to I format
it for the whole column not just one cell?


--
KSGORE
------------------------------------------------------------------------
KSGORE's Profile:

http://www.excelforum.com/member.php...o&userid=30037
View this thread: http://www.excelforum.com/showthread...hreadid=497235