Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
=A1*24
Format as General (or as Number, but don't leave it as Time as Excel did) -- Kind regards, Niek Otten "SAR" 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: http://www.excelforum.com/member.php...o&userid=34172 | View this thread: http://www.excelforum.com/showthread...hreadid=539381 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
Assuming your value is in A1 =CONVERT(A1,"day","hr") HTH, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=539381 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
"SteveG" wrote in
message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
"SAR" 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 & 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
<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" 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 & 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 | |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
You need to format the cell as general
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "SAR" 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 & 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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hours & Minutes to Decimal
Thanks - It works now. You guys are the greatest! -- SAR ------------------------------------------------------------------------ SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172 View this thread: http://www.excelforum.com/showthread...hreadid=539381 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding hours and minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Need to convert hours and minutes to hours and tenths. | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
adding rows of hours and minutes to get a total | Excel Worksheet Functions |