**How to display hours over 24 H in Excel?**

**Why Excel doesn't display hours beyond 24 hours**By default, the maximum hours is 23:59:59 in Excel

**Customize your time format**To display hours over 24 hours, you must create your own time format

But, if you change **one option** in the number format, you can display hours over 24.

## Difference between hours and days in Excel

**Rule 1 : A whole number is a day**

**Rule 2: A decimal number, between 0 and 1, is a time**

To understand this, have a look at this example

- Let's consider the value 0.5
- Convert it into
**Time format**. Excel displays 12H.

The explanation is simple. **0.5 is half of a day so it's 12H**.

## Why Excel doesn't display over 24 hours?

In this example, **all the values are in Time format**.

When you **do the sum** of the weekdays, **the duration exceeds 24 hours**. Here is column H, we have the SUM function in General format number.

But now, if you convert this result into **Time format**, all the cells show a result under 24 hours.

It's because, **after 23:59:59, it's 1 day**.

So **Excel converts the result into days for the whole number and hours for the rest** 💡

## Display hours over 24

To display hours over 24, you must customize **your number format with brackets**.

Open the custom number format.

- By using the shortcut Ctrl+1
- Or, by selecting the last menu in the
**dropdown Number Format list**

In the dialogue box **Format Cells**, write the following code with **the hour code between brackets.**

[h]:mm

- The
**[h]**between brackets means the hours over 24 hours - The
**mm**means the minute format

## Trick to Convert whole numbers to decimal numbers

If your document represents hours but in reality it's integer, like 8 for 8 hours, there is an easy way to convert all your data.

- Write the value 24 in an empty cell
- Copy it
- Select all the data to convert
- Open the dialog box Paste Special.
- Select the option
**Divide**

This video explains how to proceed.

## Related Articles

- Display negative time in Excel
- Calculation of tenths, hundredths and thousandths with Excel
- Excel Split Date and Time

Rob

22/09/2023 @ 20:40

Ok..... worked it out.

Thanks

Rob

22/09/2023 @ 10:26

Hi.

I have a cell containing a total time as 38:15 (formatted as [h]:mm). I now need to show that value as 38 Hrs 15 Min. When I use the formula =HOUR($H$33)&" Hrs "&MINUTE($H$33)&" Min", I get 14 Hrs 15 Min. The calculated cell is also formatted as [h]:mm. Anyone know how to display this correctly?

Thanks

Rob

Chris

02/02/2023 @ 04:43

you're my new BFF

Hans Hallebeek

04/11/2021 @ 08:52

Nice, but how would I go to display 123 hours and 45 minutes? [hhh]:mm ????

Frédéric LE GUEN

07/11/2021 @ 15:08

No, [h]:mm is enough if the value of the hours is 123

Clauds

12/11/2020 @ 22:35

Thank you SO much. Made it so simple and you didn't even try to sell me Ku Tools once. As of today this is the only site I found explaining how to sum up hours from decimal values spanning over months. *Bookmarking now*