Home

Welcome to OnlineConversion.com

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.


Go Back | Archive Index


 

Did you find us useful?

Please consider supporting the site with a small donation.

click here for more information

 


BookMark Us

It may come in handy.

Check out our Conversion Software for Windows.

Can't find something?
Try searching.

Are you bored?
Try the Fun Stuff.

Was this site helpful?
Link to Us | Donate