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?
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?
Multiply by 1440 (24 hours per day by 60 minutes per hour)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"KSGORE" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
Select column A and pull-down:
Format > Cells... > Number > Custom and enter [m] in the type field
--
Gary's Student
"KSGORE" wrote:
>
> 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
>
>
To convert a time into a number of minutes, multiply by 1440, then format as
a simple number (comma style, for example) rather than a time. To do this
for a whole series of numbers, type the number 1440 in some random cell.
Copy it. Then select all the times you want converted and Edit > Paste
Special. Select the 'multiply' option and click OK. Then apply the
formatting.
BTW, the logic for 1440: Excel stores dates/times as numbers, specially
formatted, with the integer portion being days and the fraction portion being
parts of a day. There are 24 hours in a day, so multiply by 24 to get the
number of hours. Then multiply by 60 to convert hours to minutes.
--Bruce
"KSGORE" wrote:
>
> 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks