TIMENOW

Returns the current time as a string (in the format "hh:mm:ss")

hour(Optional) The hour component, between 0 and 23.
minute(Optional) The minute component, between 0 and 59.
seconds(Optional) The second component, between 0 and 59.
time_format(Optional) The time format

Remarks

* You can use the TIME function to return the time as a decimal given an hour, minute, second.
* This function is never volatile and can only be updated manually
* You can use the shortcut key (Ctrl + ;) to quickly insert the date.
* You can use the shortcut key (Ctrl + Shift + ;) to quickly insert the time in "hh:mm" format.
* The equivalent VBA function is TIMENOW

 A
1equals =JS.TIMENOW()




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