Can someone please help me to get the duration in minutes for a start date time and end date time?

Kimberly Pizarra

jmyzk_cloudsmart_jp

Hi @Kimberly Pizarra

You can use the TIME function to convert AM/PM time format to 24 format, which makes it easy to calculate duration minutes.

https://app.smartsheet.com/b/publish?EQBCT=f9d46e5dbe444c3e96647a7419861e75

[Time 24] =TIME(RIGHT([Date Time]@row, 8), 1)
[Year] =VALUE(MID([Date Time]@row, 7, 2))+2000
[Month] =VALUE(LEFT([Date Time]@row, 2))
[Day] =VALUE(MID([Date Time]@row, 4, 2))
[Date] =DATE(Year@row, Month@row, Day@row)
[Hour] =VALUE(LEFT([Time 24]@row, 2))
[Minitues] =VALUE(RIGHT([Time 24]@row, 2))
[Time Minutes] =Hour@row * 60 + Minitues@row

[Duration: Total in miniutes]# =[Duration: Dates]# * 24 * 60 + [Duration: Minutes]#

https://help.smartsheet.com/function/time

format—[optional] [optional] Specifies whether the time is displayed using a 12-hour (0) or 24-hour (1) clock.

jmyzk_cloudsmart_jp

Hi @Kimberly Pizarra

You can use the TIME function to convert AM/PM time format to 24 format, which makes it easy to calculate duration minutes.

https://app.smartsheet.com/b/publish?EQBCT=f9d46e5dbe444c3e96647a7419861e75

[Time 24] =TIME(RIGHT([Date Time]@row, 8), 1)
[Year] =VALUE(MID([Date Time]@row, 7, 2))+2000
[Month] =VALUE(LEFT([Date Time]@row, 2))
[Day] =VALUE(MID([Date Time]@row, 4, 2))
[Date] =DATE(Year@row, Month@row, Day@row)
[Hour] =VALUE(LEFT([Time 24]@row, 2))
[Minitues] =VALUE(RIGHT([Time 24]@row, 2))
[Time Minutes] =Hour@row * 60 + Minitues@row

[Duration: Total in miniutes]# =[Duration: Dates]# * 24 * 60 + [Duration: Minutes]#

https://help.smartsheet.com/function/time

format—[optional] [optional] Specifies whether the time is displayed using a 12-hour (0) or 24-hour (1) clock.