software

How do I convert 2:15 TIME VALUE (2 hours and 15 minutes) to 2.25
hours?
I'm really beat on this one. Please be specific. Thanks so much.--
SAR
------------------------------------------------------------------------
SAR's Profile: www.excelforum.com/member.php...oamp;userid=34172
View this thread: www.excelforum.com/showthread...hreadid=539381=A1*24
Format as General (or as Number, but don't leave it as Time as Excel did)

--
Kind regards,

Niek Ottenquot;SARquot; gt; wrote in message ...
|
| How do I convert 2:15 TIME VALUE (2 hours and 15 minutes) to 2.25
| hours?
| I'm really beat on this one. Please be specific. Thanks so much.
|
|
| --
| SAR
| ------------------------------------------------------------------------
| SAR's Profile: www.excelforum.com/member.php...oamp;userid=34172
| View this thread: www.excelforum.com/showthread...hreadid=539381
|

Assuming your value is in A1

=CONVERT(A1,quot;dayquot;,quot;hrquot;)

HTH,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=539381
I must not be doing something right to get 2.25 hours.

I added times of day and got 2:15 (time value format-2hours amp; 15
minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,quot;dayquot;,quot;hrquot;)
with Number and General format and received #NAME?. Tried =A1*24 with
Number and General format and received 0.

Please help.--
SAR
------------------------------------------------------------------------
SAR's Profile: www.excelforum.com/member.php...oamp;userid=34172
View this thread: www.excelforum.com/showthread...hreadid=539381quot;SteveGquot; gt; wrote in
message ...
gt;
gt; Assuming your value is in A1
gt;
gt; =CONVERT(A1,quot;dayquot;,quot;hrquot;)

But remember that the CONVERT function is only available if the Analysis
ToolPak add-in is installed.
--
David Biddulph
quot;SARquot; gt; wrote in message
...
gt;
gt; I must not be doing something right to get 2.25 hours.
gt;
gt; I added times of day and got 2:15 (time value format-2hours amp; 15
gt; minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,quot;dayquot;,quot;hrquot;)
gt; with Number and General format and received #NAME?. Tried =A1*24 with
gt; Number and General format and received 0.

For CONVERT you need the Analysis ToolPak add-in.

=A1*24 should work, so my guess is that your 2:15 is not formatted as time.
Check the format of A1.
--
David Biddulph
lt;I added times of day and got 2:15 (time value format-2hours amp; 15 minutes)gt;

????Please be more specific. What exactly did you do?

quot;SARquot; gt; wrote in message ...
|
| I must not be doing something right to get 2.25 hours.
|
| I added times of day and got 2:15 (time value format-2hours amp; 15
| minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,quot;dayquot;,quot;hrquot;)
| with Number and General format and received #NAME?. Tried =A1*24 with
| Number and General format and received 0.
|
| Please help.
|
|
| --
| SAR
| ------------------------------------------------------------------------
| SAR's Profile: www.excelforum.com/member.php...oamp;userid=34172
| View this thread: www.excelforum.com/showthread...hreadid=539381
|
You need to format the cell as general

--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;SARquot; gt; wrote in message
...
gt;
gt; I must not be doing something right to get 2.25 hours.
gt;
gt; I added times of day and got 2:15 (time value format-2hours amp; 15
gt; minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,quot;dayquot;,quot;hrquot;)
gt; with Number and General format and received #NAME?. Tried =A1*24 with
gt; Number and General format and received 0.
gt;
gt; Please help.
gt;
gt;
gt; --
gt; SAR
gt; ------------------------------------------------------------------------
gt; SAR's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34172
gt; View this thread: www.excelforum.com/showthread...hreadid=539381
gt;

Thanks - It works now. You guys are the greatest!--
SAR
------------------------------------------------------------------------
SAR's Profile: www.excelforum.com/member.php...oamp;userid=34172
View this thread: www.excelforum.com/showthread...hreadid=539381