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.

 A
1=TODAY() = Sunday, May 01, 2022
2=NOW() = Sunday, May 01, 2022 18:37:54
3=MOD(A2,1) = 6:37:54 PM
4=A2-INT(A2) = 6:37:54 PM
5=TIME(HOUR(A2),MINUTE(A2),SECOND(A2)) = 6:37:54 PM

Built-in Functions

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.


Related Formulas

Return the date from a date and time


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