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() = Tuesday, October 01, 2024
2=NOW() = Tuesday, October 01, 2024 06:08:01
3=MOD(A2, 1) = 6:08:01 AM
4=A2-INT(A2) = 6:08:01 AM
5=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) = 6:08:01 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


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top