81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the fraction of a 24-hour day the time represents.

How To Use in Sheets


External Links

Create an Employee Timesheet Using Google Sheets

Create a simple template for tracking employee time, including overnight shifts, with no coding. Google Sheets allows you to share your spreadsheet with other employees, and you can protect certain cells from others.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.