Skip to content
Time Durations
Time Durations
Formulas: Days(), Hours(), Minutes(), Seconds(), and Duration()
Category: Duration
Days()Creates a time duration for days
Another way to say it...
Hours()Creates a time duration for hours
Or, as one might say...
Minutes()Creates a time duration for minutes
Another way to say it...
Seconds()Creates a time duration for seconds
Or, as one might say...
Duration()Creates a duration of time
Or, put otherwise...
Each formula—with exception of Duration()—has one parameter. Duration() combines all parameters of the other formulas:
Days, Hours, Minutes, & Seconds
Days(Days)The number of days.Hours(Hours)The number of hours.Minutes(Minutes)The number of minutes.Seconds(Seconds)The number of seconds.
Duration (Days, Hours, Minutes, Seconds)Input the number of days, hours, minutes, and seconds.
Days, Hours, Minutes & Seconds
Time-based values can be especially difficult to perform mathematical operations with. These duration formulas help you quickly turn a single number into a day, hour, minute, or second value to use within mathematical formulas.
Add days to a date
days from today it will be
45
10/29/2023
Add hours to a moment in time
hours from now it will be
7
1:00 AM
Add minutes to a time value
Lets add minutes to →
28
2:28 AM
12/31/1899 2:56 AM
Add seconds to a time value
In seconds,
132
the time will be
Duration
Duration, rather than helping you perform mathematical operations with time-based values, helps you quickly create a unique duration value.
Each one of the parameters with Duration() is optional, and you can choose which parameter you are trying to access by typing the parameter followed by a : .
5 days
5 hrs
5 mins
5 secs
Since each parameter is optional, you can use as few or as many as you like!
Practice: Use a duration formula to modify existing time values
Done
Find out when a persons work shift would end based on break time and shift length
Done
Ready to master coda yourself?
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.