Forum Discussion
Rino Comodo
Mar 09, 2019Copper Contributor
Time data issues
After selecting custom h:mm in a cell when I type 9.15 it comes up as 7:12 or something. Why? Also, in the same cell, if I double click it shows the date & time, i.e. 22/8/2018 7:12AM Any respons...
SergeiBaklan
Mar 10, 2019Diamond Contributor
Hi Rino,
In Excel dates and times are digital numbers. Date is integer part of the number and they start from Jan 01, 1900 which is equal to 1 (thus equivalent of Mar 10, 2019 will be the number 43534).
Time is decimal part, 1 hour = 1/24. Thus 6pm = 24/18 = 0.75
Formatting like h:mm is to operate with dates and time in more human friendly manner. Thus if you type 9.15 it is the equivalent of 9 days (integer part) and 3.6 (24*0.15) hours. With General format you see 9.15, with time format
Formula bar shows full date & time.