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 |
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 | |
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 |
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 |
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 |
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 |
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 | |
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 |
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 |
All times are GMT +1. The time now is 07:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com