Forum Discussion

Iron Contributor

Nov 01, 2018

Solved

Hours and times values

I really don't know if someone with "the power" will sometime read this: I wonder why Excel has that many types of input availables, but then is so poor when we talk about hours. I had to calcula...

developer

excel

SergeiBaklan
Nov 01, 2018
Arul, these are different things how to calculate the time and how to represent it. If you would like to sum 22:10 and 07:15 you may show the result as 29:25 if apply [hh]:mm format to it. In background you actually add 0.302 to 0.924 and the result is 1.226.

If you subtract the time you shall say to Excel what your time are in different days if so, but calculations have exactly the same logic, as well as formatting.

SergeiBaklan

Diamond Contributor

Nov 01, 2018

Arul, these are different things how to calculate the time and how to represent it. If you would like to sum 22:10 and 07:15 you may show the result as 29:25 if apply [hh]:mm format to it. In background you actually add 0.302 to 0.924 and the result is 1.226.

If you subtract the time you shall say to Excel what your time are in different days if so, but calculations have exactly the same logic, as well as formatting.