Excel stores time durations as days
Published on in Excel
For example, 6 hours is stored as 0.25 days.
To format a duration as hh:mm:ss.000,
first convert the duration to days.
Published on in Excel
For example, 6 hours is stored as 0.25 days.
To format a duration as hh:mm:ss.000,
first convert the duration to days.