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 & 1
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 wit
Number and General format and received 0.
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.
<I added times of day and got 2:15 (time value format-2hours & 15 minutes)>
????Please be more specific. What exactly did you do?
|
| 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?action=getinfo&userid=34172
| View this thread: http://www.excelforum.com/showthread.php?threadid=539381
|
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.