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

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" <(E-Mail Removed)> wrote in message
news:E5363E38-1F4D-439C-9EA2-(E-Mail Removed)...
> 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

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