Tag: TRUNC in Excel

  • Extract time from DateTime in Excel

    Extract time from DateTime in Excel

    The fastest way to extract time in Excel is by using the function MOD. The function MOD in Excel returns the remainder after a number divided by a divisor. In other words, you can extract decimals. The time part in DateTime is decimal numbers; by using MOD, you can get only the fractional part. By […]