Skip to main content
Question

Calculate Hours from when a user logs in to now

  • Feb 19, 2021 3:07 PM UTC
  • 0 replies
  • 27 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
------------------------------
This topic has been closed for replies.