Hours to desimal

[MikaJ69]

Hi!

How can I change hours to decimal. For example 23073:06 hours to decimal?

[#2]

@MikaJ69 

Let's say you have a time in A1, with the custom format [h]:mm.

In another cell, enter the formula =24*A1 and set the number format of the cell with the formula to General or to Number.

[#3]

@HansVogelaar 

Thanks Hans!

It works when your time number is under 10000:00:00 but when your time number is over 10000:00:00 it won't work.

[#4]

@MikaJ69 

It works for me:

[#5]

@HansVogelaar 

Hmm... strange. (#ARVO! = #VALUE!)

[#6]

@MikaJ69 

That is a quirk of Excel. You cannot enter durations of 10000 hours or more directly: Excel treats them as text values - if you look closely, you'll see that the large value is left-aligned.

Excel does handle larger durations as the result of a formula, for example by adding multiple times below 10000 hours.

[#7]

I understand. It's really a quirk that excel can't handle larger numbers. But hey, thank you very much Hans!
T. Mika