Help

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

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
398 1
cancel
Showing results for 
Search instead for 
Did you mean: 
peterboothby
5 - Automation Enthusiast
5 - Automation Enthusiast

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
peterboothby
5 - Automation Enthusiast
5 - Automation Enthusiast

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
peterboothby
5 - Automation Enthusiast
5 - Automation Enthusiast

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.