Number Conversion Issue

scroucher

New Member
Joined
Oct 17, 2006
Messages
1
I need to convert accumulated time to minutes.

Example: Someone makes a telephone call and it lasts for 1:06 (1 minutes and 6 seconds).

Is there a formula that will allow me to show this as 1.1 minutes?

Also, if a call was made that was 70:06 (70 minutes and 6 seconds), it would have to be shown as 70.1 minutes.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
This would work for time values under 24 hours:<ul>[*]=HOUR(A1)*60+MINUTE(A1)+SECOND(A1)/60[/list]
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Depends how it's entered:

If 70:06, then =A1*24
if 1:10:06 or 00:70:06, then =A1*1440
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Either way I "overdid it" (or "underthunk it" if you prefer) by dragging HOUR(), MINUTE() & SECOND() into the mix. Sheesh... :rolleyes:
 

Watch MrExcel Video

Forum statistics

Threads
1,113,859
Messages
5,544,710
Members
410,631
Latest member
JFORTH97
Top