Forum Discussion
Hours to desimal
Hi! How can I change hours to decimal. For example 23073:06 hours to decimal?
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.
I understand. It's really a quirk that excel can't handle larger numbers. But hey, thank you very much Hans!
T. Mika
T. Mika
