How to convert Time HH:MM:SS to Decimal Hours in Excel & Decimal Hours to Time HH:MM:SS

Time HH:MM:SS to Decimal HoursFormula ( 2 options)
6:30:006.5“=HOUR(D12) + (MINUTE(D12)/60) + (SECOND(D12)/60/60)”
Format cell to General
6:30:006.50“=A15/0.041666667”
Format cell to Number
Decimal Hours to Time HH:MM:SSFormula
6.56:30:00“=A15*0.041666667”
Format cell to Time

One thought on “How to convert Time HH:MM:SS to Decimal Hours in Excel & Decimal Hours to Time HH:MM:SS”

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.