Forum Discussion
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 response would be greatly appreciated.
1 Reply
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.
