Convert decimals into Excel Time

[jinh96]

Hi Everyone - I'm new to this forum. I have a very basic knowledge of Excel.

I've noticed that converting decimals to Excel Time only exists as a 24h format.
Example: 3/24 = 0.125 ->h:mm -> 3:00

However, I was wondering if there was a way to change the 24h format into an hour format.
Example: 3hours 30min -> 3.5 -> 3:30

I apologize in advance if this is a simple ask. Thanks in advance!

[MrShorty]

The base unit for Excel's date/time system is the day, so convert whatever decimal time value you have to days. One possibility =CONVERT(decimalhour,"hr","day")

Edit to add: format the cell in your desired date/time format.

[joeu2004]

I was wondering if there was a way to change the 24h format into an hour format.
Example: 3hours 30min -> 3.5 -> 3:30

If your data is in decimal hours, simply divide by 24 and format as some form of Time.

For example, if A1 is 3.5 (hours), enter =A1/24 into B1, and format as Custom [h]:mm .

I recommend always using "[h]" instead of just "h", just in case the number of hours exceeds 24.

-----

I've noticed that converting decimals to Excel Time only exists as a 24h format.
Example: 3/24 = 0.125 ->h:mm -> 3:00

I think you are confusing "conversion" with internal representation.

There is no conversion between 0.125 and 3:00 (3h 0m).

3:00 is simply how 0.125 appears when it is formatted as Custom [h]:mm because Excel time is stored as a fraction of a day.

For example, 12:34:56 (12h 34m 56s) is stored as 12/24 + 34/1440 + 56/86400 (0.524259259259259) because there are 24 hr/day, 1440 min/day and 86400 sec/day.