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 |
6 years later and your efforts are a boon to me. Many thanks!
LikeLike