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 don’t 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