To sort out this issue, you have to make changes in the number format of the values given in the cells A2, B2, and C2 to General. Remember that negative time values are displayed as #. The above-mentioned formula is not useful if the first time value is before midnight and the ending time value is after midnight. As already mentioned, time values are coded as numbers between 0 and 1, that’s why the 6:00 AM value would be as 0.25 quarter through the day.
Next, you will have to edit the number format of the values given in the cells A2, B2, and C2 to General.You can even make changes in the Time format according to your preferences. Also, note that AM is for the night and morning time whereas PM is for the afternoon and evening times.
0 kommentar(er)
