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.
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.
Assuming your value is in A1
=CONVERT(A1,"day","hr")
HTH,
Steve
=A1*24
Format as General (or as Number, but don't leave it as Time as Excel did)
--
Kind regards,
Niek Otten
"SAR" <[email protected]> wrote in message news:[email protected]...
|
| 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: http://www.excelforum.com/member.php...o&userid=34172
| View this thread: http://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 & 15 minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,"day","hr") with Number and General format and received #NAME?. Tried =A1*24 with Number and General format and received 0.
Please help.
"SteveG" <[email protected]> wrote in
message news:[email protected]...
>
> Assuming your value is in A1
>
> =CONVERT(A1,"day","hr")
But remember that the CONVERT function is only available if the Analysis
ToolPak add-in is installed.
--
David Biddulph
"SAR" <[email protected]> wrote in message
news:[email protected]...
>
> 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 & 15
> minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,"day","hr")
> with Number and General format and received #NAME?. Tried =A1*24 with
> 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
<I added times of day and got 2:15 (time value format-2hours & 15 minutes)>
????Please be more specific. What exactly did you do?
"SAR" <[email protected]> wrote in message news:[email protected]...
|
| 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 & 15
| minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,"day","hr")
| 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: http://www.excelforum.com/member.php...o&userid=34172
| View this thread: http://www.excelforum.com/showthread...hreadid=539381
|
You need to format the cell as general
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
"SAR" <[email protected]> wrote in message
news:[email protected]...
>
> 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 & 15
> minutes). 2:15 is in cell A1. Then I tried =CONVERT(A1,"day","hr")
> 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:
> http://www.excelforum.com/member.php...o&userid=34172
> View this thread: http://www.excelforum.com/showthread...hreadid=539381
>
Thanks - It works now. You guys are the greatest!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks