1/9/2024 0 Comments Time durationsSee also IF().Įxamples that compute Durations in Days, Months, or Years IF(( > ), ( - ), (( + 24) - )) : the Duration between StartWhen and StopWhen (two DateTime values).- : the Duration between StartDate (a Date) at midnight and EndDate (a Date) at midnight.TODAY() - "" : the Duration between the current Date and Decem(a Date).NOW() - "03:15:30" : the Duration between the current Time and 3:15:30 AM (a Time) on Decem(the default Date if none is included).TIMENOW() - "12:30:00" : the Duration between the current Time and 12:30 PM (a Time).+ ( - "00:00:00") : Creates a DateTime value from a Date value and a Time value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |