Decimal day fraction to time
If you copied a time cell out of Excel and got a number like 0.354166, this tool turns it back into a clock time.
Loading the tool…
Processing and privacy: The result is calculated inside your browser and your data is not sent to any server.
How to use it
- Enter decimal value.
- The result appears straight away and updates as you edit.
- Copy the result, or copy a link that keeps the same values to share it.
How it is calculated
Seconds = fraction × 86,400, rounded to the nearest second, then split into hours, minutes and seconds. The whole part is the count of full days.
Example
Inputs: Decimal value = 0.75. Result: Time HH:MM:SS: 18:00:00; 12-hour time: 6:00:00 PM; Whole days: 0.
Limits and caveats
- The result is rounded to the nearest second, so a value very close to 1 becomes 00:00:00 on the next day.
- The whole part is shown as a count of days, not converted to a calendar date.
Questions about this tool
What time is 0.5?
0.5 × 24 = 12, so it is 12:00 noon.
What does a value like 45000.25 mean?
In Excel the whole part 45000 is the date and 0.25 is the time, 06:00 AM.
Why does 0.354166 show as 8:30?
0.354166 × 86,400 = 30,599.9 seconds, which rounds to 30,600 seconds, or 8 hours 30 minutes.