Time

Enter the time in minutes:seconds (MM:SS) in a 12-hour or 24-hour format

Config

Style

Most of the style settings are self-explanatory, but here are a few tips and tricks:

How it works in Formulas

The Time field will return the number of minutes since 00:00, so you can use it in formulas like:

@TimeField1 - @TimeField2
to get the number of minutes between two time fields

SECONDS_TO_HHMMSS(@TimeField1 * 60 + 2 * 60 * 60)
will output in HH:MM:SS format the time from TimeField1 plus 2 hours

SECONDS_TO_HHMMSS(@TimeField1 * 60 + 2 * 60 * 60, 12)
will output in HH:MM:SS AM/PM format the time from TimeField1 plus 2 hours

MINUTES_TO_HHMM(@TimeField1 + 2 * 60)
will output in HH:MM format the time from TimeField1 plus 2 hours

MINUTES_TO_HHMM(@TimeField1 + 2 * 60, 12)
will output in HH:MM AM/PM format the time from TimeField1 plus 2 hours

Need Help?
Already checked the help docs? We're quick to answer and friendly
Thanks!
We'll reply very soon at
Send message