Excel Guides

Determining the Hour of the Day in Excel

To determine the hour of the day in Excel, you can use a simple formula that uses the NOW function. The NOW function returns the current date and time, so by using the HOUR function, you can extract just the hour from that value. The formula would look like this:

=HOUR(NOW())

If you want to display the hour as a number between 1 and 12, you can use the MOD function to get the remainder after division by 12. The formula would look like this:

=MOD(HOUR(NOW()),12)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.