Converting time cells from Hrs:Mins:secs to minutes

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

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)
 
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
 
Back
Top