Have a starting date/time value and need to add a min:sec duration and return the resulting date/time value. Is there a date function that allows you to do this? For example, I have a starting date/time value of “04/08/2024 14:53:11” and I need to add a duration of “14:58” (in min:sec) and want the result to show the new date/time value. Hoping there is a simple date function that will allow me to do this. Thanks for any help.
| Date&Time | Format |
|---|---|
| 2024-08-04 14:53:11 | JJJJ-MM-TT HH:MM:SS |
| 14:58 | MM:SS |
| 2024-08-04 15:08:09 | JJJJ-MM-TT HH:MM:SS |
Note
Do not use slashes as separators but hyphens.
See @erAck’s comment, now ISO format:
| Date&Time | Format |
|---|---|
| 2024-08-04 14:53:11 | YYYY-MM-DD HH:MM:SS |
| 14:58 | MM:SS |
| 2024-08-04 15:08:09 | YYYY-MM-DD HH:MM:SS |
Just add … like in the example in A3 enter =A1+A2
(and whether to use slashes or not and which order depends on your locale, but the ISO 8601 YYYY-MM-DD date format is understood in all locales; the JJJJ-MM-TT HH:MM:SS format code Grantler used is the German localized code, most locales use YYYY-MM-DD HH:MM:SS)
1 Like
105369.ods (17.4 KB)
Column A has random numbers representing date-times.
Column B has manually entered numbers representing minutes.
Column C adds minutes to date-times.
You can change the number format of any column to decimal, currency, scientific notation or whatever. It won’t have any influence on the cell values. Spreadsheets do not have any date nor time values. Dates and times are nothing but formatted numbers with an integer part representing a day number and a decimal fraction representing the time of the day.
If you format cells as [MM]:SS before entering any value, colon separated digits will be interpreted as Minutes:Seconds. Normally, it would be interpreted as Hours:Minutes.
[MM]:SS displays two hours and a half in time span format 150:00.
MM:SS would display 30:00 which means the remaining 30 minutes beyond the two hours.