Time to decimal fraction of a day
Excel and Google Sheets store a time as a number between 0 and 1. This tool gives you that number for any time of day.
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 time and seconds.
- 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
Fraction = (hours × 3600 + minutes × 60 + seconds) ÷ 86,400. Example: 18:00 = 64,800 ÷ 86,400 = 0.75.
Example
Inputs: Time = 18:00, Seconds = 0. Result: Fraction of a day: 0.75; Percent of the day: 75%; Seconds since midnight: 64,800.
Limits and caveats
- A day is taken as 86,400 seconds, ignoring daylight saving transition days.
Questions about this tool
Why does Excel show a time as 0.5?
Excel counts a whole day as 1, so noon is half a day, 0.5. Format the cell as time to see the clock value.
What is 06:00 as a day fraction?
6 ÷ 24 = 0.25, a quarter of a day.
How do I turn the fraction into hours?
Multiply by 24. Example: 0.75 × 24 = 18 hours.