Time conversion to hundredths
Time conversion to hundredths
by JCarey on 07/27/05 at 17:15:58
Information posted here about converting Time to Hundredths in Excel and the formula given
=SUM(HOUR(K4),(MINUTE(K4)/60),(SECOND(K4)/3600))
works for Time that is 9 hours and any minutes or less but when converting Total Time such as 62:45:00 it produces in error 14.75. How do I get this to produce 62.45 which represents 62 hours and 45/100?
Re: Time conversion to hundredths
by Robert Fogt on 07/28/05 at 05:01:44
That forumula converts time to decimal, not to hundreths, and since it does not take days into account it will only work for times less than 24 hours.
Try this formula here:
=SUM(DAY(A1)*24,HOUR(A1),PRODUCT(MINUTE(A1),0.01))
It does not take seconds into account, not sure how they are handled in hundreths.