Follow

How to Calculate Date and Times

Times and durations are stored as dd:hh:mm:ss
The following functions work on times or strings to return a time:


TIME(hh:mm:ss) or  TIME(hh:mm) returns the time specified as a time


MINUTES() returns number of minutes eg. MINUTES(“12:56:00”) = 56


SECONDS() returns number of seconds eg SECONDS(“12:56:23”) = 23


HOURS() returns number of hours eg. HOURS(“12:56:00”) = 12 


DAYS() returns number of days DAYS(“15:12:56:00”) = 15 


For example, to calculate 1 min 30seconds from now, you can use Audience.sender.later = NOW()+”00:01:30”

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments