2024 Date And Time In Excel. Use the today function to enter today's date in excel. What this is doing is getting the date portion of the input using left(a1,10) and converting it into datevalue and getting the time portion using mid(a1,12,8) and converting it into timevalue.
To return the hour, use the hour function. Use the today function to enter today’s date in excel.