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
------------------------------
Question
Calculate Hours from when a user logs in to now
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.