Reply
Regular Visitor
Posts: 24
Registered: ‎08-03-2018
Accepted Solution

Time Since Calculation

I have to calculate a the hours/minutes since a date/time stamp column i am using the below formula but it is producint the current time and not the hours/ minutes since the date time column.  All of the date and times in the column are within the past 24 hours . 

 

Since_Arrived_Time = now()-OfficeTrax[Arrived Date].[Date] 

 


Accepted Solutions
Highlighted
Established Member
Posts: 255
Registered: ‎03-31-2016

Re: Time Since Calculation

[ Edited ]

Hi @abehrmann

 

Try 

 

Since_Arrived_Time = DATEDIFF(OfficeTrax[Arrived Date].[Date],now(),MINUTE)

 

 

View solution in original post


All Replies
Highlighted
Established Member
Posts: 255
Registered: ‎03-31-2016

Re: Time Since Calculation

[ Edited ]

Hi @abehrmann

 

Try 

 

Since_Arrived_Time = DATEDIFF(OfficeTrax[Arrived Date].[Date],now(),MINUTE)