Converting time cells from Hrs:Mins:secs to minutes
 

Hi i am trying desperately to convert telephone logs from the format
hrs:min:secs into minutes and have had no joy. For example

i want 10:10:10 presented as 610.17 minutes

Any help will be grately appreciated

Richard

Converting time cells from Hrs:Mins:secs to minutes
 

Use formula like

=A1*24*60

where A1 is the time value. Be sure to format the formula cell as General,
not Time (Excel will try to help by automatically applying a Time format --
its help is not welcome in this instance).


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Richard" wrote in message
...
Hi i am trying desperately to convert telephone logs from the format
hrs:min:secs into minutes and have had no joy. For example

i want 10:10:10 presented as 610.17 minutes

Any help will be grately appreciated

Richard

Converting time cells from Hrs:Mins:secs to minutes
 

If your time is a real Excel time, it's just a fraction of a day. So
10:10:10 if formatted as General should display as 0.423726852

Now there are 1440 minutes in a day. So if A1 contains:
10:10:10
then =A1*1440 will display 610.1667
--
Gary''s Student - gsnu200793


"Richard" wrote:

Hi i am trying desperately to convert telephone logs from the format
hrs:min:secs into minutes and have had no joy. For example

i want 10:10:10 presented as 610.17 minutes

Any help will be grately appreciated

Richard