Calculating a Building's Occupancy Rate at Specified Times

Problem: Columns B & C show the times that each of a building's tenants left and returned on a particular day. We want to calculate the buildi...

How to round time values up to nearest hour in Excel

In this article, we will learn How to round time values up to the nearest hour in Excel. Scenario: Generally, we are stuck at time fields and ...

Rounding Times Down to the Nearest 30 Seconds

Problem: Rounding the times ("hh:mm:ss") in column A down to the nearest 30 seconds. Solution 1: Use the ROUNDDOWN function as shown in the f...

Creating a World Time Converter

Problem: Finding the equivalent time for the city in cell C5 (Jerusalem) as that shown in cell D2 for the city in cell C2 (New York). Solution: ...

Converting Time Values from One Time Zone to Another

Listed in cells B1:E2 are several destinations and their hourly time difference with New York. We want to convert the time value in cell B3 (New York...

How to convert time to decimals in Excel

In this article, we will learn How to convert time to decimals in Excel. Scenario: Excel Stores Time in General number format. So to convert...

Converting a Decimal Value to a Time Value

Problem: Converting the decimal values in column A to correctly formatted time values. Solution: Divide each number by 24 as follows: =A2/24 ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.