Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Hours to Decimal
Hi everybody! I have in a cell 40:23:04, which is number of hours and equals to 40.38 hours or to 2423.07 minutes. To convert the first value, I wrote the following formula: =HOUR(A1567)+MINUTE(A1567)/60+SECOND(A1567)/3600. I dont think this formula is appropriate, moreover it doesn't work properly for values greater than 24h. My final goal is to convert 40:23:04 hours to 2423.07 minutes So, which function should I use and how to solve the problem? Thank you in advance. -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=499663 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Hours to Decimal
Just multiply your value by 24 and by 60, as follows:
= A1 * 24 * 60 if your value is in cell A1. Format as number with 2 decimal places. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Hours to Decimal
Assume your cell is A1, try this formula in A2:
=ROUND(A1*1440,2) N.B. 1440=24*60 Regards, Stefi dminkov ezt *rta: Hi everybody! I have in a cell 40:23:04, which is number of hours and equals to 40.38 hours or to 2423.07 minutes. To convert the first value, I wrote the following formula: =HOUR(A1567)+MINUTE(A1567)/60+SECOND(A1567)/3600. I dont think this formula is appropriate, moreover it doesn't work properly for values greater than 24h. My final goal is to convert 40:23:04 hours to 2423.07 minutes So, which function should I use and how to solve the problem? Thank you in advance. -- dminkov ------------------------------------------------------------------------ dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757 View this thread: http://www.excelforum.com/showthread...hreadid=499663 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
How do I sum hours in Excel and convert to decimal numbers? | Excel Discussion (Misc queries) | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions |