Skip to main content
Question

Calculate Hours from when a user logs in to now

  • February 19, 2021
  • 0 replies
  • 16 views

Hi Team,

I created a formula which essentially calculates the # of hours between when an office opens to now (whereas each office opens at 8am local):

var number Hr=Hour(ToTimeOfDay(Now())-Hours(8))+Minute(ToTimeOfDay(Now()))/60;
If($Hr<0,0,If($hr>8,8,$hr))​

I'm having difficulty converting this formula so that i can leverage a different Start time timestamp. Any thoughts?

------------------------------
GMacri
------------------------------