Forum Discussion
Built-in date format based on Datevalue
Dear members,
I have noticed while working on date decoding that the excel returns incorrect date on datevalue (one day less). For example the data given in follwing table calculates day as 5th of july since the number 42920 completes seconds till 4th of july and we are now on the next day with .2802546.... time passed on the 5th. My working file is attached for further evaluation. I need help if I am wrong in my assumption.
| 3708312214 | Dec Value in Seconds past 1900 | ||
| 42920.280254629600 | Days.Time | ||
| 7/4/2017 6:43:34 AM | Through Excell built in format | ||
| 42920 | Days | ||
| 117.5890411 | year.Days | ||
| 117 | Year | ||
| 215 | Days | ||
| 30 | Leap Year Adj | ||
| 185 | Total Days | ||
| 7 | Month | ||
| 5 | Day | Added one to count for hours past last day ie 4th july | |
| 6.726111111 | Hours.Seconds | ||
| 6 | Hours | ||
| 43.567 | Min.sec | ||
| 43 | Min | ||
| 34 | Sec |
1 Reply
Hi,
Perhaps you took incorrect starting point in your calculation. Zero is Jan 00, 1900 (1900-00-00 00:00) and when the previous century starts on Jan 01, 1900 (1900-01-01 00:00:00) that's 1.
