Return the time from a date and time
You can remove the date component from a date and time by using the MOD function.
This function will return the remainder after division.
The remainder after dividing a number by 1 will remove the integer part of the number.
There are some other formulas that could also be used.
Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays just the time from cell "A2".
Cell "A4" displays just the time from cell "A2". This formula uses subtraction to remove the date integer.
Cell "A5" displays just the time from cell "A2". This formula reconstructs a time using the individual components.
TODAY - The serial number representing today's date.
NOW - The serial number of the current system date and time.
MOD - The remainder after division.
TIME - The time as a decimal given an hour, minute, second.
INT - The number rounded down to the nearest integer.
HOUR - The hour as an integer given a date serial number.
MINUTE - The minute as an integer given a date serial number.
SECOND - The number of seconds as an integer given a date serial number.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top