SharePoint List Formatting
Back to column formats
Column formattingSharePoint Online

World Time

This sample demonstrates displaying the times of countries and regions of the world for a date column value that includes the time.

Get this format View on GitHub

Shared by Tetsuya Kawahara
Updated Mar 3, 2023

World Time formatting preview
Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Column formatting
Download JSON
{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "display": "flex",
    "flex-direction": "row"
  },
  "children": [
    {
      "elmType": "div",
      "txtContent": "@currentField.displayValue"
    },
    {
      "elmType": "div",
      "style": {
        "cursor": "pointer",
        "padding": "5px",
        "margin": "5px",
        "border-radius": "3px",
        "font-size": "16px",
        "visibility": "=if(@currentField,'visible','hidden')"
      },
      "attributes": {
        "iconName": "World",
        "class": "ms-bgColor-themePrimary--hover ms-fontColor-white--hover"
      },
      "customCardProps": {
        "openOnEvent": "hover",
        "directionalHint": "rightCenter",
        "isBeakVisible": true,
        "formatter": {
          "elmType": "div",
          "children": [
            {
              "elmType": "div",
              "style": {
                "display": "flex",
                "flex-direction": "column",
                "padding": "15px 20px",
                "width": "570px"
              },
              "children": [
                {
                  "elmType": "div",
                  "forEach": "UTC in split('-8|Seattle,-5|New-York,0|Portugal,2|Finland,5.5|India,9|Japan',',')",
                  "style": {
                    "display": "flex",
                    "flex-direction": "row",
                    "justify-cotent": "center",
                    "align-items": "center",
                    "margin": "5px",
                    "width": "100%"
                  },
                  "children": [
                    {
                      "elmType": "div",
                      "txtContent": "=replaceAll(substring([$UTC],indexOf([$UTC],'|')+1,indexOf([$UTC]+'^','^')),'-',' ')",
                      "style": {
                        "width": "12%",
                        "word-wrap": "break-word"
                      }
                    },
                    {
                      "elmType": "div",
                      "style": {
                        "width": "8%",
                        "text-align": "center",
                        "margin": "0px 5px"
                      },
                      "children": [
                        {
                          "elmType": "span",
                          "txtContent": "=padStart(toString(floor(((Number(@currentField)+Number(substring([$UTC],0,indexOf([$UTC],'|')))*3600000)%86400000)/3600000)),2,'0')"
                        },
                        {
                          "elmType": "span",
                          "txtContent": ":"
                        },
                        {
                          "elmType": "span",
                          "txtContent": "=padStart(toString(floor(((Number(@currentField)+Number(substring([$UTC],0,indexOf([$UTC],'|')))*3600000)%86400000)%3600000/60000)),2,'0')"
                        }
                      ]
                    },
                    {
                      "elmType": "div",
                      "style": {
                        "width": "80%",
                        "height": "80%",
                        "position": "relative",
                        "display": "flex",
                        "align-items": "center"
                      },
                      "children": [
                        {
                          "elmType": "div",
                          "style": {
                            "display": "flex",
                            "flex-direction": "row",
                            "justify-content": "space-around",
                            "border": "2px solid",
                            "width": "100%",
                            "height": "100%"
                          },
                          "attributes": {
                            "class": "ms-fontColor-themePrimary"
                          },
                          "children": [
                            {
                              "elmType": "div",
                              "style": {
                                "display": "=if(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1==0,'none','flex')",
                                "width": "=if(Number(substring([$UTC],0,indexOf([$UTC],'|')))>0,((1-abs(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1))*100)+'%',(abs(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1)* 100)+'%')",
                                "text-align": "center"
                              },
                              "attributes": {
                                "class": "=if(abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)<=5||abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)>=22,'ms-bgColor-themePrimary ms-fontColor-white','')"
                              }
                            },
                            {
                              "elmType": "div",
                              "forEach": "hour in split('0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23',',')",
                              "txtContent": "=ceiling(abs((24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24))",
                              "style": {
                                "width": "=if(Number([$hour])==23,if(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1==0,'100%',if(Number(substring([$UTC],0,indexOf([$UTC],'|')))>0,(abs(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1)*100)+'%',((1-abs(Number(substring([$UTC],0,indexOf([$UTC],'|')))%1))*100)+'%')),'100%')",
                                "text-align": "center"
                              },
                              "attributes": {
                                "class": "=if(abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)<=5||abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)>=22,'ms-bgColor-themePrimary ms-fontColor-white',if(abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)<=8||abs(ceiling(24+Number(substring([$UTC],0,indexOf([$UTC],'|')))+Number([$hour]))%24)>=19,'ms-bgColor-themeLight',''))"
                              }
                            }
                          ]
                        },
                        {
                          "elmType": "div",
                          "style": {
                            "position": "absolute",
                            "width": "1.5%",
                            "height": "100%",
                            "left": "=((Number(@currentField)%86400000)/3600000)/24*100+'%'"
                          },
                          "attributes": {
                            "class": "ms-bgColor-neutralTertiary"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    }
  ]
}
View sourceLink to this definitiondate-world-time.json
Schema compatibility review notes

This historical definition differs from the pinned Microsoft schema. This may indicate an unsupported pattern or a schema limitation. Check the original requirements and test in your tenant before use.

  • /children/1/customCardProps/formatter/children/0/children/0/children/2/children/0/children/1/forEach must match pattern "^[^\]\$@\. ]+ in (\@currentField|\[\$.+\])$"

From the contributor

How to use this sample

Summary

This sample demonstrates displaying the times of countries and regions of the world for a date column value that includes the time.

screenshot of the sample

  • The countries and regions to display can be added or removed by editing the string of the first argument of the split operator on line 45. The following notes apply to editing that string.

    • The string must be [time difference from UTC]|[name of country or region] separated by commas.
    • If you want to use spaces for the country or region name, use - (half-width hyphen). The - (half-width hyphen) will be replaced with a half-width space and displayed on the screen. Including spaces in the string will prevent the custom card from displaying.

  • Here is an example of the settings for line 45:

    "forEach": "UTC in split('-8|Seattle,-5|New-York,0|Portugal,2|Finland,5.5|India,9|Japan',',')",

View requirements

This format can be applied to a Date column.

Sample

Solution Author(s)
date-world-time.json Tetsuya Kawahara

Version history

Version Date Comments
1.0 March 3, 2023 Initial release

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Keep exploring

More formats like this

Missing Information Callout

The Missing Information Callout column formatter provides a clear, accessible visual indicator when a SharePoint list column contains no value.

Explore format

Publishing Status

Sample contains an example of using the modulo math expression for highlighting 'published', 'published with draft' and 'draft with no published versions' of pages

Explore format

File Preview Callout with the embed Action

This sample demonstrates how to display a file preview from a document library or Site Pages inside a callout using the embed action. This allows users to view file contents without leaving the current page.

Explore format