Convert function not working sec to min

  • Thread starter Thread starter Lovelock, David
  • Start date Start date
L

Lovelock, David

I am using the following function and getting the #NAME? error. Can
anyone help?

=convert(F13, "sec", "mn")

F13 currently has the following formula:
=SUM(F5:F12)

which equals 132.67 which represents the number of seconds recorded. I
want to convert that to minutes.

Thanks,

Dave
 
Hi Dave!

Works OK for me!

I've replicated your problem statement

F13:
=SUM(F5:F12)
Returns: 132.67

F15:
=CONVERT(F13, "sec", "mn")
Returns: 2.211167

What problem are you getting?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I am using the following function and getting the #NAME? error. Can
anyone help?

=convert(F13, "sec", "mn")

F13 currently has the following formula:
=SUM(F5:F12)

which equals 132.67 which represents the number of seconds recorded. I
want to convert that to minutes.

Thanks,

Dave
Click to expand...

1. Do you have the Analysis TookPak Add-In enabled?
2. Why not just use =SUM(F5:F12)/60 ?
 
Dave probably hasn't installed ATP which convert is a part of..

--

Regards,

Peo Sjoblom


Norman Harker said:
Hi Dave!

Works OK for me!

I've replicated your problem statement

F13:
=SUM(F5:F12)
Returns: 132.67

F15:
=CONVERT(F13, "sec", "mn")
Returns: 2.211167

What problem are you getting?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Click to expand...
 
I am using the following function and getting the #NAME? error. Can
anyone help?

=convert(F13, "sec", "mn")
Click to expand...

From Excel HELP:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron
 
You need to have the Analysis Toolpak Addin -- use
tools/add-ins, and check it, then it should work.
 
Doh!!!

Didn't "see" the mention of #NAME?

Time for bed!!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Peo Sjoblom said:
Dave probably hasn't installed ATP which convert is a part of..
Click to expand...
 
Back
Top