Calculating The Time for Another Time Zone

TB PCI · 11/26/24

Smartsheet Community:

Is There a Formula I can Use to Pull The Time for The Modified Date Column Type and Add 6 Hours to Give Me That Time?

Example:

Current CST Time (Column Type is Modified Date) = 11/26/24 4:08 PM

Current CST Time Plus 6 Hours 9Column Type is Text) = 10:08 PM

Thanks

Melissa Yamada · 11/27/24

Hello @TB PCI ,

I'd be happy to help!

A possible solution is creating additional 3 columns aside from the Modified Date column.

For example, Modified Time, Plus 6 hrs, and CST Time columns. Formula you can use are:

Here is a screenshot of my sample:

You may check this articles for reference:

Paul Newcome · 11/27/24

The challenge with the above would be if it rolls into the next day. Even something like going from AM to PM will have the wrong results.

There is a solution in the below linked thread that accommodates moving from AM to PM as well as moving into the next day if needed.

TB PCI · 11/27/24

Thanks @Melissa Yamada Is there a Formula for The Time Column?

Melissa Yamada · 11/28/24

Yes sorry I forgot to include, formula is =RIGHT(Modified@row, 7)

Answers