The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

What's the formula to subtract 3 hours from Time & Date Field but...

posted Mar 31, 2024 2:57:31 AM

Topic Labels: Dates & Timezones Formulas

Solved

Jump to Solution

0 1030 1

Does anyone know the formula to subtract 3 hours from date and time field but... show just the time please? This formula provides the correct answer showing date and time but...

DATEADD(

{Departure Date & Time},

-3,

'hours'

)

...when I add this to the formula to they and show just time -- the time is completely wrong.

DATETIME_FORMAT(

DATEADD(

{Departure Date & Time},

-3,

'hours'

),

'h:mmA'

)

My attempts have resulted in a series of #Errors. Any ideas please? Thank you.

1 Solution

Accepted Solutions

Solved

I fixed it. Was fiddling all day and then sorted it 5 seconds after this post. 'Use the same time zone for all collaborators' was off.

See Solution in Thread

1 Reply 1

Solved

I fixed it. Was fiddling all day and then sorted it 5 seconds after this post. 'Use the same time zone for all collaborators' was off.