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.

	A
1	=TODAY() = Friday, November 29, 2024
2	=NOW() = Friday, November 29, 2024 11:44:05
3	=MOD(A2, 1) = 11:44:05 AM
4	=A2-INT(A2) = 11:44:05 AM
5	=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) = 11:44:05 AM

1 - Displays the current date. Custom format "dddd dd mmmm yyyy".
2 - Displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
3 - Displays just the time from cell "A2".
4 - Displays just the time from cell "A2". This formula uses subtraction to remove the date integer.
5 - Displays just the time from cell "A2". This formula reconstructs a time using the individual components.

Built-in Functions

TODAY - The date serial number representing today's date.
NOW - The date 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.

Related Formulas

Return the date from a date and time