| Time HH:MM:SS to Decimal Hours | Formula ( 2 options) | |
| 6:30:00 | 6.5 | “=HOUR(D12) + (MINUTE(D12)/60) + (SECOND(D12)/60/60)” |
| Format cell to General | ||
| 6:30:00 | 6.50 | “=A15/0.041666667” |
| Format cell to Number | ||
| Decimal Hours to Time HH:MM:SS | Formula | |
| 6.5 | 6:30:00 | “=A15*0.041666667” |
| Format cell to Time |
You must be logged in to post a comment.