Deduct 1 hour in the Calculated Field in Pivot

Hi All,

I was wondering if we can deduct 1 hour in this calculated field

=cf_Total_Logged_in_Time-'CMS Stafftime' <--- Original formula

I was thinking of going like this but to no avail

=(cf_Total_Logged_in_Time-'CMS Stafftime')-Time:1:00))

any help is greatly appreciated

Try this:

=cf_Total_Logged_in_Time-'CMS Stafftime'-Time(1,0,0)

Or:

=cf_Total_Logged_in_Time-'CMS Stafftime'- 1/24

Hi Phuocam,

Apologies for the super late reply
But you're formula helped in solving our dilemma
Thanks a bunch