# Number Conversion Issue

#### scroucher

##### New Member
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.

### 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
This would work for time values under 24 hours:<ul>[*]=HOUR(A1)*60+MINUTE(A1)+SECOND(A1)/60[/list]

=A1*24

#### Greg Truby

##### MrExcel MVP
¡¡DOH!! <ul>[*]=A1*24*60[/list]

#### Scott Huish

##### MrExcel MVP
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
Either way I "overdid it" (or "underthunk it" if you prefer) by dragging HOUR(), MINUTE() & SECOND() into the mix. Sheesh...

Replies
5
Views
88
Replies
1
Views
87
Replies
3
Views
206
Replies
2
Views
95
Replies
1
Views
29