I am looking to convert Date and time in excel.
Column H (Age) = Age in Calendar Days (Decimal form)
Column I (Create Node) = Date Created
For example in cell I2 "
2018-06-12-09.20.37.391580-T.01"I know that the first 8 numerical digits are the create date "2018-06-12". I also believe that the next 6 digits that come after are the Hours "20.47.39" and posibly the rest is just specific to the seconds but not that important.
Is there and easy way to convert Everything in column I from the current date and time excluding weekends and holidays? Enter in Column M.