Forum Discussion
Solved
Adding Hours Column to Date/Time Column
Hi All, I've a calculated column containing hours (Date type- Decimal Number) and also a date/time column, I want to add the hours to the date/time column but there is many different hours/date v...
So, date/time is actually a decimal number where the integer portion is the number of days since December 30th, 1899 and the decimal portion is the time component. So, to add hours you will need to add it as the decimal part. So, for example, 1 AM is .0416666667 (1 / 24 ).
So, date/time is actually a decimal number where the integer portion is the number of days since December 30th, 1899 and the decimal portion is the time component. So, to add hours you will need to add it as the decimal part. So, for example, 1 AM is .0416666667 (1 / 24 ).
Thank you very much, Worked perfectly!
