Forum Discussion
Excel formula
Hi, A question for calculation hours not coming in decimal, for example start hours 21:00 - 06:00 my calculation will come to 09:00 I need to have just 9 not decimal as it affects on all of my formu...
Unfortunately not working it comes to 00:00. The hours is 21:00 - 07:00 in roster not based on Am and PM.
Sorry The hours is 21:00 till 06:00 not based on am or pm. I tried so many times with 24*, it comes to 00:00. Also Just wanted to read as 9 without decimal.
If your cell is showing 00:00, then you need to change the format from a time format (hh:mm) to a number format. In Excel, the integer part of a number is days and the decimal is time. An hh:mm format will only display the decimal part, which is zero, so you need to change the format to see the integer.